VBA & Macro Problems

Fix Blocked Excel Macros After Changing Security Settings

Muhammad TalhaMuhammad Talha Nov 18, 2026 869 views

Question details

The user needs to make macros available in an Excel workbook that remains blocked after security settings and trusted locations were checked.

Fix Blocked Excel Macros After Changing Security Settings
Product
Microsoft Excel
Device & OS
not provided
Scenario
The user wants to run macros in a workbook after changing macro security settings and reopening the file.
Observed behavior
The macros remain unavailable, potentially because Excel does not trust the workbook's source or publisher.
Before you start

Read the exact security message in Excel and confirm that you trust the workbook and its source before enabling any macros. Check that the file uses a macro-enabled format such as .xlsm; the Windows steps below may differ on other systems.

Solution 1Recommended

Unblock a Trusted Workbook Downloaded From the Internet

Use this method when Excel says macros are blocked because the file's source is untrusted.

1
Close the workbook

Close the workbook in Excel, then locate the saved file in Windows File Explorer.

2
Open file properties

Right-click the workbook, select Properties, and look for an Unblock checkbox on the General tab.

3
Unblock and reopen

If Unblock is available and you trust the file, select it, click Apply, and reopen the workbook in Excel.

4
Check the security message

If Excel displays a security warning, read it and use Enable Content only if you trust the workbook and the option is offered.

Unblock a Trusted Workbook Downloaded From the Internet
No Unblock option?: The file may not have a Windows download block, or an organization policy may restrict it. Check the exact Excel message and contact your administrator if the block remains.
Free Microsoft Office alternative

Work With Spreadsheets in WPS Office

WPS Office is a free, lightweight alternative with a familiar spreadsheet interface and support for common Microsoft Office formats, making it easy to move everyday spreadsheet work. It does not change Microsoft Excel's macro security settings.

Open and edit common spreadsheet files in a familiar interfaceCompatible with Microsoft Excel XLSX filesContinue everyday spreadsheet work without relying on ExcelFree and lightweight for routine Office tasks
microsoft office alternative - wps office

Frequently Asked Questions

Why are macros still blocked after I change Excel's macro settings?

Excel can block a file because it came from an untrusted source, even when macro settings have been changed. Read the security message and, on Windows, check the file's Properties > General tab for an Unblock option.

Does removing the workbook author unblock macros?

No. The author field under File > Info > Properties > Advanced Properties is document metadata; removing it does not establish publisher trust or remove a Windows download block.

How do I check whether a folder is trusted in Excel?

In Excel for Windows, go to File > Options > Trust Center > Trust Center Settings > Trusted Locations. Compare the listed paths and subfolder settings with the workbook's actual location.

Can an XLSX file contain VBA macros?

The standard XLSX format does not retain VBA macros. Use File > Save As and select Excel Macro-Enabled Workbook (.xlsm) for a workbook that needs VBA.

What if my organization blocks macros?

If Excel reports that the setting is managed by your organization, contact your IT administrator with the exact warning and the workbook's source. Organization policy may prevent you from changing the relevant setting.