VBA & Macro Problems

How to Fix Macros Still Disabled After Enabling VBA in Excel

John Wilson Oct 10, 2026 868 views

Question details

The user is unable to run macros in an Excel workbook because the macros remain disabled despite the VBA settings being enabled in the Trust Center.

How to Fix Macros Still Disabled After Enabling VBA in Excel

Product: Microsoft Excel
Device & OS: not provided
Scenario: Attempting to execute macros in an Excel spreadsheet after adjusting Trust Center settings to allow them.
Observed behavior: Macros continue to be blocked and disabled by the system, often due to underlying file security restrictions, missing trusted locations, or organization-wide IT policies.

Before you start

Ensure the Excel file you are trying to open is from a reliable and verified source before adjusting any security settings, as enabling macros can expose your computer to malicious scripts.

Solution 1Recommended

Add a Trusted Location in the Office Trust Center

Moving the blocked Excel file to a designated Trusted Location bypasses standard macro restrictions and allows VBA code to run securely.

Instead of globally enabling all macros, adding a specific local folder to your Trusted Locations is the safest way to ensure your macro-enabled workbooks function properly.

Open Trust Center Settings

Launch Microsoft Excel, click on 'File', and select 'Options' at the bottom left. In the Excel Options dialog, click 'Trust Center' and then click the 'Trust Center Settings' button.

Access Trusted Locations

In the left-hand navigation pane of the Trust Center window, select 'Trusted Locations'.

Add a New Location

Click the 'Add new location' button. Use the 'Browse' button to navigate to a secure local folder on your computer where you intend to store your macro-enabled files.

Confirm and Test

Check the box to 'Subfolders of this location are also trusted' if necessary, then click 'OK' on all open dialogs to save the settings. Move your Excel file into this newly trusted folder and reopen it.

Add a Trusted Location in the Office Trust Center

Safe Execution: Files placed in a Trusted Location will automatically run macros without triggering security warnings.

Solution 2

Unblock the File in Windows Properties

Remove the 'Mark of the Web' security feature that automatically blocks macros in files downloaded from the internet or email.

Solution 3

Consult the IT Administrator

Verify if a company-wide group policy is overriding your local Excel Trust Center settings on managed devices.

Free Microsoft Office alternative

Experience Seamless Compatibility with WPS Office

If strict Microsoft Office security policies and persistent macro issues disrupt your workflow, consider trying WPS Office. It provides robust spreadsheet capabilities with a lightweight design and excellent file compatibility.

Highly compatible with Microsoft Excel formats, including .xlsx and .xlsm files.Free to download and lightweight, ensuring fast installation and smooth operation.Familiar tabbed user interface, meaning zero learning curve when switching from Excel.Comprehensive spreadsheet functionality for professional data analysis and reporting.

microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel block macros even after I enabled VBA in the Trust Center?

Excel employs multiple layers of security to prevent malicious code execution. Even if VBA is enabled globally, Windows may block the specific file using 'Mark of the Web' if it was downloaded from the internet, or it may be blocked by your company's IT Group Policy.

Is it safe to select 'Enable all macros' in the Trust Center?

Selecting 'Enable all macros' is highly discouraged. Doing so overrides important security prompts and leaves your computer vulnerable to potentially dangerous scripts hidden in unrecognized files. Using Trusted Locations is a much safer alternative.

What if the 'Unblock' checkbox is missing from my file properties?

If the 'Unblock' option isn't visible, the file is not being restricted by Windows' download security feature. In this case, the macro is likely disabled because it is not stored in a Trusted Location or an IT administrator has enforced a macro-blocking policy.

Can I add a network drive to my Trusted Locations?

Yes, but you must specifically allow it. In the Trust Center under Trusted Locations, you must check the box that says 'Allow Trusted Locations on my network (not recommended)' before you can add a network path. Consult your IT department before doing this.

Excel & Data Problems