How to turn on, turn off, delete Macro in Excel

Macros are tools that allow you to automate tasks in Excel. Macros help you save more time processing data in Excel, bringing greater efficiency at work. If you are new to macros in Excel, then turning on, off, and deleting macros is not well understood. The manipulation of macros is not difficult, but if you do not know, please refer to the article below.

Here are instructions on how to enable, disable, delete Macro in Excel, invite you to track.

Turn on Macros

If you open an Excel file that contains a Macro, you will see a yellow warning bar, if the Excel file is reliable, you can turn on the Macro by selecting Enable Content on the warning bar.

Or you can turn on the Macro by selecting File , in the Security Warning area, click Enable Content -> Enable All Content to enable all contents of the file including Macros.

Delete Macro

Step 1 : In Excel file, select Developer -> Macros.

Thus the Macro dialog box will be displayed.

If you do not see the Developer tab on the Ribbon of Excel, then you do the following:

1. Select File -> Options.

2. On the Excel Options window, select Customize Ribbon in the left menu. In the Main Tabs section on the right, you tick the box before Developer and then click OK . Thus Developer tab will be displayed on the Ribbon .

Step 2: In the Macro dialog box , if you want to delete any Macro, click the Macro name in the Macro name list and click Delete to delete.

Step 3 : A confirmation message appears Do you want to delete macros? (Do you want to delete the macro?) select Yes to agree to delete.

Turn off Macros temporarily

Step 1: Click File -> Options.

Step 2 : In the Excel Options window, select Trust Center in the left menu, then select Trust Center Settings.

Step 3 : Choose Macro Settings, in the Macro Settings section on the right you have many options:

1. Disable all macros without notification: Disable all macros and no notifications.
2. Disable all macros with notification: Disable all macros that include notifications.
3. Disable all macros except digitally signed macros: Disable all macros except digitally signed macros .
4. Enable all macros (not recommended; potentially dangerous code can run): allow all macros (not recommended; dangerous code can run)

You select Disable all macros with notification and click OK to agree.

So you know how to enable, disable, delete macros in Excel, now you can easily work with macros more. Hopefully this article will help you in need of learning about macros. Good luck!