How to Disable Macros Microsoft Excel

Updated on:

May 12, 2026

By:

Use this interactive demo to learn how to turn off macros in Microsoft Excel via Trust Center settings.

Quick summary

To disable macros in Microsoft Excel, navigate to File > Options > Trust Center > Macro Settings and select your preferred restriction level. This process lets you control macro security to protect your workbooks from potentially harmful automated scripts.

Steps

Open Microsoft Excel and click on "File" in the top menu.
Navigate to "Options" at the bottom of the File menu sidebar.
In the Excel Options dialog, select "Trust Center" from the left-hand panel.
Open "Macro Settings" and choose which macro disable option you want to apply.
Confirm your changes by clicking "OK" to save the updated macro security settings.

📌 Why this matters

Controlling macro security in Microsoft Excel is essential for protecting your organization from malicious or unauthorized automated scripts embedded in workbook files. By disabling macros through the Trust Center, IT administrators and everyday users can enforce a safer Excel environment without removing macro functionality entirely. Excel's built-in Macro Settings offer granular control — from blocking all macros silently to allowing only digitally signed ones — making it a critical step in any Microsoft 365 security baseline. Understanding how to disable macros reduces the risk of malware delivery via Excel files, a common attack vector in enterprise environments.

Your product deserves an interactive demo

Start free

How to Organize Dates by Week in Excel

How to Make Cells Fit Text Microsoft Excel

How to Make a Bar Graph in Microsoft Excel