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

By default, Microsoft Excel employs a strict security posture regarding Visual Basic for Applications (VBA) macros. Whenever you open a workbook containing embedded macro code, Excel completely blocks the code from executing and displays a prominent yellow security warning bar beneath the ribbon, forcing you to manually click “Enable Content.”

This protection is absolutely critical for average users, as malicious macros are a primary vector for ransomware infections. However, if you are a data analyst operating entirely within a secure, isolated corporate intranet, or if you write your own macros and frequently open dozens of trusted automation scripts throughout the day, this constant manual clicking becomes an infuriating bottleneck. If you absolutely guarantee that every single .xlsm file you open is 100% safe and you want your scripts to execute instantaneously upon launch, you can completely disable the security warnings and force Excel to run all macros automatically.

Disabling Macro Warnings via the Trust Center

You must explicitly instruct Excel to bypass its own security checks by diving into the Trust Center settings.

1. Open the Microsoft Excel desktop application.
2. Look at the main menu ribbon at the top of the screen and click on File (in the top-left corner).
3. Scroll to the absolute bottom of the left-hand blue sidebar and click on Options.
4. A new Options window will appear. In the left-hand menu, scroll to the bottom and click on Trust Center.
5. In the main panel, click the large button labelled Trust Center Settings….
6. A second window will open. In the left-hand menu, click on Macro Settings.
7. You will see a list of four radio buttons. Select the absolute lowest, least secure option:
   Enable all macros (not recommended; potentially dangerous code can run).
8. (Optional but recommended for developers): Check the box below it labelled Trust access to the VBA project object model.
9. Click OK on both open windows to save the changes.

Extreme Warning: You have now completely removed Excel’s primary defense mechanism against malicious payloads. If you download an Excel file from the internet or receive one as an email attachment and open it, any embedded malware will execute instantly and silently, without asking for permission. You must only use this setting on heavily firewalled workstations where you have absolute control over the origin of every file.