VBA & Macro Problems

Fix Excel Security Settings That Disable Workbook Macros

John WilsonJohn Wilson Nov 18, 2026 870 views

Question details

Find out why Excel disables macros in a workbook that previously worked and how to restore access safely.

Fix Excel Security Settings That Disable Workbook Macros
Product
Microsoft Excel
Device & OS
not provided
Scenario
A user opens a macro-enabled workbook and wants to run its embedded VBA macros.
Observed behavior
Excel disables the macros, and the Macro dialog does not allow the user to change macro options.
Before you start

Confirm that you trust the workbook and its source before allowing its macros to run. The file Properties and Trust Center instructions below apply to Excel on Windows; managed devices may restrict these controls.

Solution 1Recommended

Check the Workbook Block and Excel Trust Settings

Use these checks when Excel blocks a trusted workbook or its macro settings cannot be changed.

1
Check file properties

Close the workbook, then right-click the file in Windows File Explorer and select Properties. On the General tab, select Unblock if it appears, then click Apply and OK.

2
Reopen the workbook

Open the workbook in Excel. If a security warning offers Enable Content and you trust the file, select it to allow the macros.

3
Review macro settings

In Excel, go to File > Options > Trust Center > Trust Center Settings > Macro Settings. If available, choose the option to disable VBA macros with notification so you can decide whether to enable trusted content when prompted.

4
Check trusted locations

In Trust Center Settings, select Trusted Locations. If your organization permits it, add a folder with Add new location and place only trusted workbooks there; then reopen the workbook from that folder.

5
Ask an administrator

If Trust Center controls are grayed out or the workbook remains blocked, contact your organization's IT administrator and describe the warning. Group policy or another security control may be preventing macros from running.

Check the Workbook Block and Excel Trust Settings
Keep macro security in place: Do not enable macros for unknown files or use a trusted location for files from untrusted sources. The Macro dialog is for working with macros, not overriding security policies.
Free Microsoft Office alternative

Work With Excel Files in WPS Spreadsheets

WPS Office is a free, lightweight alternative with a familiar interface for opening and editing Excel files. Its format compatibility helps you move existing spreadsheets into WPS, although it does not change Excel security policies or guarantee that VBA macros will run.

Open and edit spreadsheets with familiar worksheet toolsCompatible with Microsoft Excel formats such as XLSX and XLSMove existing Excel files into a lightweight office suiteReview workbook data without changing Excel macro security settings
microsoft office alternative - wps office

Frequently Asked Questions

Why are the macro settings grayed out in Excel?

Your organization may control them through group policy or another security setting. Check File > Options > Trust Center > Trust Center Settings > Macro Settings, then contact your administrator if the controls are unavailable.

Where can I find the Unblock option for a workbook?

On Windows, close the workbook, right-click it in File Explorer, and select Properties. Look for Unblock on the General tab; it appears only for certain files marked as coming from another source.

Is it safe to put a workbook in a trusted location?

Use a trusted location only for files you trust, because Excel treats content in that folder as trusted. In Excel, review or add locations under File > Options > Trust Center > Trust Center Settings > Trusted Locations, if your organization allows it.

Why can't I change macro security from the Macro dialog?

The Macro dialog is used to view and run macros, not to override security settings. Review Macro Settings in the Trust Center or ask your administrator if those settings are controlled by policy.

Will WPS Office remove Excel's macro security restrictions?

No. WPS Office is a separate application and cannot change Excel's security settings or organizational policies. VBA macro compatibility in WPS may also vary.