VBA & Macro Problems

How to Fix Excel Macros Disabled Despite Trust Center Settings

Amos Gikunda Oct 15, 2026 870 views

Question details

Excel continues to block VBA macros from running, even after the user has explicitly enabled them within the Trust Center settings.

How to Fix Excel Macros Disabled Despite Trust Center Settings

Product: Microsoft Excel
Device & OS: not provided
Scenario: Attempting to execute a VBA macro in an Excel workbook that was received via email, downloaded from the internet, or transferred from another computer.
Observed behavior: A security alert appears stating that macros have been disabled, or the macros fail to run despite the Trust Center settings being configured to allow VBA macros.

Before you start

Before proceeding, verify that the workbook containing the macro comes from a trusted and reliable source, as enabling macros in unknown files can expose your system to malicious software.

Solution 1Recommended

Unblock the Downloaded Workbook Properties

Use this solution if the workbook was downloaded from the internet or received via email. Windows automatically flags these files, forcing Excel to block macros regardless of Trust Center settings.

Modern versions of Windows apply a security tag called 'Mark of the Web' to files originating from another computer or the internet. Excel reads this tag and aggressively blocks macros to protect your system.

Close the Workbook

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

Open File Properties

Navigate to the folder where the workbook is saved. Right-click the Excel file 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', then click 'Apply' and 'OK'. Reopen the file in Excel and try running the macro.

Unblock the Downloaded Workbook Properties

Batch Unblocking: If you frequently work with downloaded macro files, you can save them in a designated 'Trusted Location' to avoid unblocking them one by one.

Solution 2

Verify Antivirus Software Status

Use this method if unblocking the file does not work. Excel integrates with Windows Security to scan macros, and issues with your antivirus can cause macros to be disabled.

Solution 3

Add Folder to Excel Trusted Locations

Instead of lowering global security settings by enabling all macros, designate a specific folder as a Trusted Location so Excel allows all macros within that folder to run safely.

Free Microsoft Office alternative

Try WPS Office for Seamless Spreadsheet Management

If you frequently encounter strict security blocks, missing features, or complex Trust Center settings in Microsoft Excel, consider switching to WPS Office. It provides a highly compatible, lightweight, and user-friendly spreadsheet environment without the heavy configuration overhead.

1. Download and Install: Visit the official WPS website to download and install the free WPS Office suite.
2. Open Your Workbooks: Launch WPS Spreadsheet and open your existing Microsoft Excel files directly.
3. Enjoy Hassle-Free Editing: Continue editing, formatting, and saving your data with high compatibility and robust features.

Highly compatible with Microsoft Excel formats, including .xlsx, .xls, and .csvStreamlined security settings that balance system safety with user convenienceLightweight design ensures fast loading and smooth performance on any deviceFamiliar ribbon user interface requires no learning curve to switch seamlessly

microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel say macros are disabled when I just enabled them in the Trust Center?

This usually happens because the file was downloaded from the internet or another computer. Windows applies a 'Mark of the Web' to downloaded files, which forces Excel to block the macros for security reasons regardless of your Trust Center settings. You must right-click the file, go to Properties, and check 'Unblock'.

Should I just enable all macros globally in the Trust Center to fix this?

No, enabling all macros globally via registry changes or Trust Center settings is a significant security risk. It allows potentially malicious scripts to run on your computer without warning. It is much safer to unblock specific files or use Excel's Trusted Locations feature.

Can my antivirus software block Excel macros?

Yes. Modern versions of Excel integrate closely with your system's antivirus through the Antimalware Scan Interface (AMSI). If your antivirus detects an issue, or if the antivirus itself is inactive or malfunctioning, Excel will block the macro from executing to keep your system safe.

How do I trust a specific folder in Excel?

You can bypass individual file blocks by adding a folder to your Trusted Locations. Go to File > Options > Trust Center > Trust Center Settings > Trusted Locations, and click 'Add new location' to specify a folder where your safe workbooks are stored.

Excel & Data Problems