Fix Excel Security Settings That Disable Workbook Macros
Question details
Find out why Excel disables macros in a workbook that previously worked and how to restore access safely.

- 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.
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.
Check the Workbook Block and Excel Trust Settings
Use these checks when Excel blocks a trusted workbook or its macro settings cannot be changed.
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.
Open the workbook in Excel. If a security warning offers Enable Content and you trust the file, select it to allow the macros.
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.
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.
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.

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.

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.




