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.

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

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.

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

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.

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

Delete Macro

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

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

Thus the Macro dialog box will be displayed.

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

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

1. Select File -> Options.

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

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 .

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

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.

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

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.

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

Turn off Macros temporarily

Step 1: Click File -> Options.

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

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

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

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.

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

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!