How to Activate Macros in Excel Safely：Easy Way

When a trusted workbook opens but its buttons, forms, or automated reports do nothing, Excel has probably disabled its VBA macros. The right fix depends on the warning you see: a yellow Security Warning bar, a Trust Center restriction, or a red Security Risk banner on a downloaded file.

This guide shows how to activate macros in Excel without lowering protection for every workbook. Verify the sender and the expected macro behavior first. If you cannot explain what the code should do, keep it disabled.

How to Activate Macros in Excel Safely

How to Activate Macros in Excel for One Trusted Workbook

Use this method when Excel shows a yellow Security Warning bar with an Enable Content button. It activates the workbook as a trusted document without changing the default for unrelated files.

1. Confirm that the workbook came from a person or system you trust.

2. Ask what the macro is expected to change, create, send, or import.

3. Open the workbook in the desktop version of Excel. Excel for the web cannot run VBA macros.

4. If Protected View appears, review the file before selecting Enable Editing.

5. On the yellow Security Warning bar, select Enable Content.

6. Run the intended control or choose Developer > Macros, select the macro, and click Run.

If the file does not display a prompt, continue to the Trust Center method. Do not solve a missing prompt by turning on every macro globally.

Excel Enable Content security banner

Use Word, Excel, and PPT for FREE

Free Download

Activate Excel Macros Through Trust Center Settings

Use Trust Center when the yellow bar is missing or when you need Excel to notify you about macros on a case-by-case basis. Microsoft lists Disable VBA macros with notification as the default behavior for ordinary trusted-document decisions. It is safer than Enable VBA macros, which allows potentially dangerous code to run in any workbook.

1. Open Excel and choose File > Options.

2. Select Trust Center, then click Trust Center Settings.

3. Open Macro Settings.

4. Select Disable VBA macros with notification.

5. Leave Trust access to the VBA project object model cleared unless a known solution specifically requires programmatic access to VBA projects.

6. Click OK twice, close the workbook, and reopen it.

7. For the verified file, use the Security Warning bar to activate its macros.

For organization-managed computers, Group Policy may lock these options. If the controls are unavailable, contact your IT administrator instead of trying to bypass the policy.

Excel Trust Center macro settings

How to Activate Macros Excel Blocks as an Internet File

A workbook downloaded from a browser, email, chat, or some cloud locations can carry Windows' Mark of the Web. Current Microsoft 365 security may show a red Security Risk banner with no Enable Content button. Changing Macro Settings alone does not remove that file-level block.

1. Close the workbook and exit Excel.

2. In File Explorer, right-click the .xlsm, .xlsb, or macro-enabled template file.

3. Select Properties and stay on the General tab.

4. At the bottom, select Unblock, then click Apply and OK.

5. Reopen the workbook and activate its macros only after confirming the source and purpose.

Use Unblock for an individual file you have already verified. For recurring company templates, an administrator can use a controlled Trusted Location or a trusted publisher. Avoid trusting a broad Downloads folder or an entire external site merely to remove prompts.

Unblock downloaded XLSM file properties

Use Word, Excel, and PPT for FREE

Free Download

Fix Activate Macro Excel Problems That Still Remain

If a verified macro still does not run, work through these checks before weakening security:

• Check the format: VBA cannot be stored in a normal .xlsx file. Use .xlsm for a macro-enabled workbook or .xlsb when the workbook intentionally uses the binary format.

• Use desktop Excel: the browser version can open the workbook data but does not run VBA.

• Show the Developer tab: go to File > Options > Customize Ribbon and select Developer.

• Check the macro list: open Developer > Macros. If the expected macro is absent, it may be stored in another workbook, add-in, or PERSONAL.XLSB.

• Review file protection: protected sheets or workbooks can prevent a macro from changing the intended cells.

• Check external dependencies: missing add-ins, broken references, moved files, or a 32-bit/64-bit API mismatch can stop otherwise trusted VBA.

• Respect policy: if Trust Center settings are locked, only your administrator can change the governing policy.

When diagnosing unfamiliar code, keep macros off and ask the workbook owner for a signed version, documentation, or an export that does not require VBA.

Open macro enabled workbook safely

A Free Spreadsheet Alternative: WPS Office

If you need to inspect or edit the data in a macro-enabled workbook without Microsoft Excel, WPS Spreadsheet can open common Excel-compatible formats, including XLSM. You can review cells, formulas, and layout locally before deciding whether any automation should run.

Macro execution is a separate compatibility question. VBA availability can depend on the WPS build and installed runtime, and complex Excel automation may not behave identically. Keep a backup, test on a copy, and use desktop Excel when a business-critical workflow depends on full VBA compatibility. For a related workflow, see how to open an XLSM file safely.

1. Open WPS Office and choose Spreadsheets.

2. Select Menu > Open and choose the macro-enabled workbook.

3. Review the sheets with macros disabled first.

4. If the automation is essential, confirm that your WPS installation supports the required VBA code and test it on a duplicate file.

WPS Spreadsheet opens XLSM workbook

Use Word, Excel, and PPT for FREE

Free Download

FAQs

Why is there no Enable Content button in Excel?

A red Security Risk banner usually means Windows marked the downloaded file as coming from the internet. Close Excel and use the file's Properties > Unblock option only after verifying the source. A company policy can also remove the button.

Should I choose Enable all macros in Excel?

No for normal use. That setting allows macro code in future workbooks to run with far less protection. Keep notification-based blocking and approve only a workbook you trust.

Which Excel file types can contain VBA macros?

Common macro-capable formats include XLSM and XLSB, plus macro-enabled templates such as XLTM. XLSX cannot retain VBA code.

Can I activate Excel macros on a Mac?

Excel for Mac can run supported VBA macros, but the Windows Properties > Unblock method does not apply. Use Excel's macro security preferences and enable only known code.

Can WPS Spreadsheet run every Excel macro?

No guarantee should be assumed. WPS can open XLSM data, but VBA support and compatibility vary by build, runtime, and code complexity. Test a copy before relying on it.

Free Office Download

   

• Use Word, Excel, and PPT for FREE, No Ads.

• Edit PDF files with the powerful PDF toolkit.

• Microsoft-like interface. Easy to learn. 100% Compatibility.

• Boost your productivity with WPS's abundant free Word, Excel, PPT, and CV templates.

Free Download

100% secure

Algirdas Jasaitis