

Thus, the macros in this macro-enabled file are all available. Then click the button “Enable Content” in the “Security Warning”. But now you are sure that this macro is safe, you can reopen the file. If you directly open the Visual Basic editor and run a macro, you will again see the information shows that macros are disabled. And there is also a button “Enable Content”. Under this option, when opening a macro-enabled workbook, you will see the security warning. And the difference between the two options is the notification. This is the effect of the first option in macro settings.īy default, Excel will choose this option for macro settings. The macros in this file are all disabled and you are unable to run any of them. When you press the button “F5” on the keyboard or click the button “Run Sub” in the toolbar, you will see this information like the image shows. But the macros in the file are all in design mode. However, you can still open the Visual Basic editor and check the codes. The next time you open a macro-enabled Excel workbook, you will not see any notifications about macros. Suppose you will never use any macros and want to disable them, you may choose this option.


Then click the button “Macro Security” in the “Code” area.Now click the tab “Developer” in the ribbon.Thus, you have added the tab to the Excel ribbon. Next click the button “OK” to save the setting.In the “Excel Options” window, check the tab “Developer” in the “Main Tabs” area.And then choose the option “Customize the Ribbon” in the pop-up menu.Right click any of a tab in the ribbon.If you have already added the tab, you can go to step 5 directly. There are four options that you could choose from.īefore you use this method, you need to add the “Developer” tab in the ribbon. Thus, you can see all the settings in the window. And then in this “Trust Center” window, choose the option “Macro Settings”.After that, click the button “Trust Center Settings”.Next in the “Excel Options” window, click the last option “Trust Center”.Below are the steps about those two different methods. And in Excel, there are two methods to do this. Open the Macro Settings Dialogīefore you modify the settings, you need to open the macro settings window. Hence, correctly enabling/disabling macros macro is rather important. If you run those macros unintentionally, your Excel could be damaged. However, there will also be dangers in some macro-enabled workbooks. Macro is very effective in dealing with complex tasks.
DISABLE MACROS IN EXCEL 2016 HOW TO
Therefore, today we will talk about how to enable/disable macros in your Excel. The security of macro is a key element for the security of Excel.
