Excel Guides

How to Get Rid of the Enable Macros Notice in Excel

If you're sick of seeing the "Enable Macros" notice every time you open an Excel workbook, there are a few things you can do to get rid of it.

First, you can go into the Trust Center settings and disable the option that displays the message. To do this, open Excel and go to File > Options > Trust Center > Trust Center Settings. Then, under the " Macro Settings " section, select " Disable all macros except digitally signed macros ."

If you still want to be able to use macros, but don't want to see the message every time, you can add specific workbooks to a "Trusted Locations" list. Excel will only display the message for workbooks that are not in a trusted location. To do this, go to File > Options > Trust Center > Trust Center Settings and then click on the " Trusted Locations " tab. From here, you can add or remove locations as needed.

Finally, if you really want to get rid of the message and don't mind making a small change to your registry, you can do that as well. Just be aware that making changes to your registry can be risky, so be sure to back it up before proceeding.

To make the change, open the Registry Editor by going to Start > Run, typing "regedit", and pressing Enter. Then, navigate to the following key:

[HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\Excel\Security] 
"VBAWarnings"=dword:00000002 

(The "16.0" in the path will be different if you're using a different version of Office.)

Next, find the "VBAWarnings" entry in the right-hand pane and double-click on it. Change the value from "2" to "0", click OK , and then close the Registry Editor.

Note: If there is no "VBAWarnings" entry in the registry key above, you can create it by right-clicking in the right-hand pane and selecting New > DWORD (32-bit) Value . Name it "VBAWarnings", set the value to "0", and then click OK .

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.