How to Completely Disable ‘Macro Warnings’ (Enable All Macros) in Microsoft Excel

Microsoft Excel features a strict security model designed to protect users from malicious code. By default, whenever you open a workbook containing VBA (Visual Basic for Applications) macros, Excel completely blocks the code from running and displays a yellow warning bar at the top of the spreadsheet. You must manually click “Enable Content” every single time you open the file before any of your automated scripts, custom buttons, or complex formulas will function.

While this is a necessary safeguard for users who download random spreadsheets from the internet, it is incredibly tedious for financial analysts, developers, and data scientists who work exclusively with trusted, internally developed macro workbooks. If you are opening and closing the same trusted automated reports twenty times a day, clicking that yellow warning bar quickly becomes a massive waste of time. If you understand the risks and want your VBA code to execute instantly the moment a file is opened, you must completely disable Excel’s macro security warnings.

Disabling Macro Warnings via the Trust Center

You can force Excel to blindly trust all VBA code by changing the global security settings within the Trust Center.

1. Open the Microsoft Excel desktop application.
2. Bypass the Start Screen by clicking Blank workbook to enter the main editing interface.
3. Look at the main menu ribbon at the top of the screen and click on File.
4. Scroll to the absolute bottom of the left-hand blue sidebar and click on Options.
5. A new Options window will appear. In the left-hand menu, click on Trust Center (it is the very last item on the list).
6. In the main panel, click the large button labelled Trust Center Settings….
7. A new dialogue box will open. In the left-hand menu, click on Macro Settings.
8. You will see a list of four radio buttons governing VBA execution. Select the absolute bottom option: Enable all macros (not recommended; potentially dangerous code can run).
9. (Optional but recommended for developers) Directly below that, check the box labelled Trust access to the VBA project object model.
10. Click OK to close the Trust Center, and then click OK again to close the Excel Options.

The change takes effect immediately. The next time you open a .xlsm or .xlsb file, Excel will not hesitate. The yellow warning bar will be gone, and all your custom VBA scripts will be armed and ready to execute the very millisecond the workbook renders on your screen.