VBA & Macro Problems

How to Fix Excel Macros Blocked Even After Enabling VBA Macros

Rana Garcia Oct 10, 2026 868 views

Question details

The user is unable to run Excel macros because they are blocked due to coming from an untrusted source, even after enabling macros in the Trust Center settings.

How to Fix Excel Macros Blocked Even After Enabling VBA Macros

Product: Microsoft Excel
Device & OS: not provided
Scenario: Trying to run VBA macros in a workbook downloaded from the internet or received from an external source.
Observed behavior: Excel displays a security warning that macros were blocked because the file came from an untrusted source, overriding the standard VBA macro settings.

Before you start

Before modifying your security settings or unblocking a file, verify that the workbook comes from a reliable sender and is completely safe to execute.

Solution 1Recommended

Unblock the File in Windows Properties

Use this method to remove the internet security block from a single, trusted workbook downloaded to your computer.

Modern Office security automatically applies a "Mark of the Web" to files downloaded from the internet. You must manually unblock the file in Windows to allow its macros to run.

Close the workbook

Ensure the Excel file is completely closed before attempting to change its properties.

Open file properties

Right-click the blocked Excel file in your Windows File Explorer and select Properties from the context menu.

Unblock the file

On the General tab, look at the bottom for a Security section. Check the box next to Unblock, click Apply, and then click OK. You can now reopen the file and run the macros.

Network Drives: If the file is stored on a network drive, the Unblock option might not be available. In that case, you will need to add the network path to your Trusted Locations.

Solution 2

Add the Folder to Excel Trusted Locations

If you frequently work with safe files from a specific folder, you can designate it as a Trusted Location to bypass the macro block automatically.

Free Microsoft Office alternative

Seamlessly Handle Spreadsheets and Macros with WPS Office

If you are struggling with Microsoft Excel's strict macro blocking policies, consider using WPS Office. It provides a lightweight, free alternative with excellent format compatibility, a familiar interface, and straightforward macro management.

1. Download WPS Office: Visit the official WPS website to download and install the free office suite.
2. Open your workbook: Launch WPS Spreadsheet and open your downloaded macro-enabled file.
3. Enable macros: Navigate to the Developer tab to easily configure and manage your macro execution settings.

Fully compatible with Microsoft Excel formats, including macro-enabled workbooks (.xlsm).Free, lightweight, and easy to install on any operating system.Familiar user interface ensures a seamless migration from Microsoft Office without a steep learning curve.Straightforward Developer tools to manage your scripts and macro security levels.

microsoft office alternative - wps office

Frequently Asked Questions

Why are my macros blocked even after enabling them in Trust Center?

Microsoft Office introduced a security policy that automatically blocks macros in files downloaded from the internet, known as the Mark of the Web. This internet security layer overrides your standard Trust Center VBA settings.

How can I unblock multiple Excel files at once?

To unblock multiple files simultaneously, the most efficient method is to move all the trusted files into a single folder, and then add that specific folder to your Excel Trusted Locations via the Trust Center settings.

Is it safe to unblock downloaded Excel files?

You should only unblock files if you completely trust the sender and know the file's contents are safe. Malicious macros can execute harmful code and compromise your system security.

Excel & Data Problems