VBA & Macro Problems

Fix Disabled Macros in Excel for Microsoft 365 After Enabling Content

Muhammad TalhaMuhammad Talha Nov 13, 2026 871 views

Question details

The user needs to determine why Excel still reports disabled macros after enabling content and adding the workbook location as trusted.

Product
Excel for Microsoft 365
Device & OS
Windows 10
Scenario
Opening a macro-enabled workbook whose content has already been enabled and whose folder has been added to trusted locations.
Observed behavior
A macro-disabled warning continues to appear despite the user's trust and content settings.
Before you start

Confirm that the workbook comes from a trusted source before allowing its macros to run. Record the exact warning text and identify whether it appears inside Excel or in a separate security-software window.

Solution 1Recommended

Check Excel macro settings, the trusted folder, and downloaded-file blocking

Use this approach when the warning appears in Excel and the workbook should be allowed to run trusted macros.

Enabling content does not override every security restriction. A downloaded-file block, an incorrect trusted-folder path, or an organization-managed policy can prevent macros from running.

1
Review macro settings

In Excel, select File > Options > Trust Center > Trust Center Settings > Macro Settings. Review the selected setting. For normal use, keep VBA macros disabled with notification rather than enabling all macros globally. If the settings are locked or managed by your organization, contact your IT administrator.

2
Verify the exact trusted location

In Trust Center Settings, select Trusted Locations. Compare the listed folder with the workbook's actual location in File Explorer. If the workbook is in a subfolder, check whether the trusted-location entry allows subfolders. Use Add new location only for a controlled folder containing files you trust.

3
Check for an internet download block

Close the workbook. In Windows File Explorer, right-click the workbook and select Properties > General. If an Unblock checkbox appears, select it only after verifying the file's source, then click Apply > OK. If Unblock is absent, proceed with the other checks.

4
Reopen the workbook and check the warning

Open the workbook again from the verified folder. If Excel displays a standard security warning with an Enable Content button, use it only for the trusted workbook. If the message instead says Microsoft has blocked macros because the source is untrusted, check the file block and trusted-location settings rather than enabling all macros.

Check Excel macro settings, the trusted folder, and downloaded-file blocking
Organization policies can override local settings: If the warning persists or trust settings cannot be changed, an administrator may need to review the applicable Office security policy. Do not attempt to bypass organizational restrictions.
Free Microsoft Office alternative

Use WPS Spreadsheet for Everyday Workbook Editing

WPS Office is a free, lightweight alternative with a familiar interface and Microsoft Office format compatibility for an easy transition. Use WPS Spreadsheet for everyday workbook viewing and editing; it does not repair Excel's macro security settings, and VBA support depends on the WPS edition and environment.

View and edit workbook data when your immediate task does not require running VBA macros.Supports Microsoft Excel .xlsx and .xls formats for everyday spreadsheet work.A familiar spreadsheet interface makes migration from Microsoft Office straightforward.A lightweight Office suite with free tools for documents, spreadsheets, and presentations.
microsoft office alternative - wps office

Frequently Asked Questions

Why are macros still disabled after I click Enable Content?

Enable Content does not override every restriction. Check File > Options > Trust Center > Trust Center Settings for macro settings and trusted locations, then check the workbook's Windows Properties for an Unblock option. An organization policy or separate security application may also be responsible.

Why does my trusted location not allow the workbook's macros?

The workbook may be outside the exact folder listed in Trust Center > Trusted Locations, or it may be in a subfolder that the entry does not cover. Compare the actual file path with the trusted-location entry. Network locations and organization policies can impose additional restrictions.

Should I enable all macros to remove the warning?

No. Enabling all macros globally can allow malicious code to run and may not resolve policy or security-software blocks. Use notification-based macro settings and approve only verified workbooks through an appropriate trust method.

Where is the Unblock option for a downloaded Excel workbook?

Close the workbook, right-click it in Windows File Explorer, and select Properties > General. If Windows has marked the file as downloaded from another source, an Unblock checkbox may appear near the bottom. Use it only after verifying the file's source.

Can WPS Office fix Excel's disabled-macro warning?

No. WPS Office does not change Excel's Trust Center settings or Microsoft Office security policies. WPS Spreadsheet can be an alternative for everyday workbook tasks, but confirm VBA support in your specific WPS edition before relying on macro-dependent workflows.