VBA & Macro Problems

How to Unblock Macros from a Trusted Source in Microsoft Office

Aamir Naveed Akram Sep 29, 2026 869 views

Question details

The user needs to unblock macros in a downloaded Office file that are being restricted by security settings despite coming from a known and trusted source.

How to Unblock Macros from a Trusted Source in Office

Product: Microsoft Office
Device & OS: Windows
Scenario: Opening an Excel spreadsheet, Word document, or PowerPoint presentation containing macros that was downloaded from the internet, an email attachment, or a network drive.
Observed behavior: Microsoft Office completely blocks the macros from running due to the Mark of the Web (MotW) or organization group policies, even if the user has enabled all macros in the Trust Center.

Before you start

Before proceeding, ensure that you completely trust the sender and the source of the file, as enabling macros from unknown or malicious sources can severely compromise your computer's security.

Solution 1Recommended

Remove the Mark of the Web via File Properties

This is the most common and direct method to unblock a specific file downloaded from the internet.

Windows applies a hidden tag called 'Mark of the Web' (MotW) to files downloaded from the internet or received via email. Office checks this tag and blocks macros accordingly. Removing this tag allows the file to run normally.

Close the Office File

Ensure the blocked Excel, Word, or PowerPoint file is completely closed before attempting to change its properties.

Open File Properties

Locate the file in File Explorer, right-click on it, and select 'Properties' from the context menu.

Unblock the File

In the 'General' tab, look at the very bottom for a Security section. Check the box or click the button labeled 'Unblock'.

Apply Changes

Click 'Apply' and then 'OK' to save the changes. Open the file again to confirm the macros now function.

Quick Tip: If you do not see the 'Unblock' option in the Properties menu, the file may not have the Mark of the Web, and the block might be caused by an IT administrator policy instead.

Solution 2

Move the File to a Trusted Location

Use this method if you frequently download trusted macro files and want them to open automatically without unblocking each one manually.

Solution 3

Unblock Using PowerShell

This method is ideal for advanced users or administrators who need to unblock files quickly using the command line.

Free Microsoft Office alternative

Try WPS Office for High Compatibility and Familiar Features

If you are tired of dealing with restrictive security policies and complex settings in Microsoft Office, consider switching to WPS Office. It provides a lightweight, highly compatible environment for your spreadsheets, documents, and presentations with a familiar interface.

1. Download and Install: Visit the official WPS website to download the free installer and follow the quick setup wizard.
2. Open Your Office Files: Double-click your existing .xlsm, .docx, or .pptx files to open them directly in WPS Office without format conversion.
3. Enjoy Seamless Productivity: Edit your documents and spreadsheets smoothly in a lightweight interface that feels instantly familiar.

Highly compatible with Microsoft Office formats like .xlsx, .xlsm, .docx, and .pptxLightweight installation that runs smoothly on most Windows PCsFamiliar user interface for a seamless migrationFree to use with built-in PDF tools and advanced editing capabilities

microsoft office alternative - wps office

Frequently Asked Questions

Why does Microsoft Office block macros even if they are enabled in the Trust Center?

Office relies on a Windows security feature called 'Mark of the Web' (MotW). If a file has this tag because it was downloaded from the internet or an email, Office blocks the macros by default to protect you from malware, overriding your standard Trust Center settings.

Can my IT administrator block me from unblocking macros?

Yes. Organizations can deploy Group Policies that permanently disable internet macros or restrict you from adding Trusted Locations. If you cannot unblock the file using Properties or Trusted Locations, you will need to contact your IT administrator.

Does moving the file to a network drive remove the block?

Not necessarily. If the network drive itself is not configured as a Trusted Location or is considered an intranet zone by Windows, the file might still retain the Mark of the Web or trigger security blocks. Using a local Trusted Location is usually more reliable.

What formats typically contain macros that trigger these blocks?

The block usually affects macro-enabled file extensions in Microsoft Office, most commonly .xlsm (Excel Macro-Enabled Workbook), .docm (Word Macro-Enabled Document), and .pptm (PowerPoint Macro-Enabled Presentation).

Excel & Data Problems