How to disable macro execution in Microsoft Office documents downloaded from the internet
Summary
This guide helps you troubleshoot and resolve: How to disable macro execution in Microsoft Office documents downloaded from the internet. Follow the steps below to fix the issue.
Common Causes
Macros are small programs embedded in Microsoft Office documents that can automate repetitive tasks. However, they are also a common delivery method for malware and ransomware. Disabling macro execution helps protect your organisation from malicious code running automatically when you open a document.
This article explains how to block macro execution in Microsoft Office documents downloaded from the internet. The setting Disable all macros without notification blocks macros in all Office documents, including files downloaded from the internet. When combined with Protected View for files originating from the internet, this provides a layered defence against malicious code in downloaded documents.
Quick Fix Steps
- Open any Microsoft Office application (such as Word, Excel, or PowerPoint).
- Select File from the top menu.
- Click Options at the bottom of the left-hand pane.
- Choose Trust Center, then click Trust Center Settings...
- Select Macro Settings from the list on the left.
- Enable the option Disable all macros without notification.
- Click OK to save your changes.
Detailed Instructions
Step 1: Open Trust Center Settings
- Launch Microsoft Word, Excel, or PowerPoint on your Windows computer.
- Click the File tab in the top-left corner of the window.
- Scroll down the left-hand menu and select Options.
- In the Word Options (or Excel/PowerPoint Options) window, click Trust Center.
- Click the Trust Center Settings... button on the right side.
Step 2: Configure Macro Settings
- In the Trust Center window, select Macro Settings from the left-hand list.
- Select the radio button for Disable all macros without notification. This prevents macros from running in all Office documents, including those downloaded from the internet, without prompting you.
- If you want to be warned before macros run instead of blocking them entirely, choose Disable all macros with notification.
- Click OK to apply the setting, then click OK again to close the Options window.
.docm for Word, .xlsm for Excel, and .pptm for PowerPoint. Standard formats such as .docx, .xlsx, and .pptx do not contain macros. Be especially cautious with macro-enabled files downloaded from the internet.Step 3: Verify Protected View for Internet Files
Protected View is a security feature that opens files downloaded from the internet in a restricted mode, preventing potentially malicious content from running. This setting is directly relevant to documents downloaded from the internet and works alongside macro settings to protect your organisation.
- Return to the Trust Center in Options.
- Select Protected View from the left-hand list.
- Ensure the checkbox Enable Protected View for files originating from the internet is checked.
- Click OK to save your changes.
Troubleshooting
Macro Settings are Greyed Out
If the macro settings options cannot be changed, your organisation may be managing Office settings through Group Policy. Contact your IT administrator or Open a Ticket for assistance.
You Need to Run a Trusted Macro
If you have a document from a known, trusted source that requires macros, you can open the file and enable content for that specific session via the yellow security bar at the top of the document. Only do this if you are certain the file is safe.
Mac Users
Mac users follow a different menu path. In Word, Excel, or PowerPoint for Mac, select Preferences from the application menu, then choose Security or Privacy depending on your version. Look for macro security options and select the setting to disable macros without notification. Protected View functionality differs on Mac, so exercise additional caution when opening documents downloaded from the internet.
Still Having Issues?
💻 Open a Ticket