Home › Knowledgebase › KB-744

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.

Quick Tip: Need immediate assistance? 💻 Open a Ticket

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.

This guide applies to Microsoft 365 subscription versions and standalone Office versions installed on Windows computers. Macro settings must be applied per-user on each computer where Office is installed.

Quick Fix Steps

  1. Open any Microsoft Office application (such as Word, Excel, or PowerPoint).
  2. Select File from the top menu.
  3. Click Options at the bottom of the left-hand pane.
  4. Choose Trust Center, then click Trust Center Settings...
  5. Select Macro Settings from the list on the left.
  6. Enable the option Disable all macros without notification.
  7. Click OK to save your changes.

Detailed Instructions

Step 1: Open Trust Center Settings

  1. Launch Microsoft Word, Excel, or PowerPoint on your Windows computer.
  2. Click the File tab in the top-left corner of the window.
  3. Scroll down the left-hand menu and select Options.
  4. In the Word Options (or Excel/PowerPoint Options) window, click Trust Center.
  5. Click the Trust Center Settings... button on the right side.

Step 2: Configure Macro Settings

  1. In the Trust Center window, select Macro Settings from the left-hand list.
  2. 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.
  3. If you want to be warned before macros run instead of blocking them entirely, choose Disable all macros with notification.
  4. Click OK to apply the setting, then click OK again to close the Options window.
Macro-enabled file formats include .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.
Do not select Enable all macros. This allows potentially dangerous code to run automatically and puts your business at risk of malware infection.

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.

  1. Return to the Trust Center in Options.
  2. Select Protected View from the left-hand list.
  3. Ensure the checkbox Enable Protected View for files originating from the internet is checked.
  4. 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.

Remember that macro settings are user-specific. If multiple users share a computer, each user must apply these settings in their own Office profile.

Still Having Issues?

Need more help? If the issue persists after trying these steps, please open a support ticket and our team will assist you.

💻 Open a Ticket