How to Enable Macros in Excel

Turn on macros so a spreadsheet's automation can run — the safe per-file way, the Trust Center settings, showing the Developer tab, and the one security rule that matters.

By the Quiriz Team · Published July 24, 2026 · 4 min read

The quick answer: when you open a macro-enabled file, click Enable Content on the yellow bar at the top. That's the safe, per-file way. If you want to change the setting permanently, it lives in File → Options → Trust Center → Trust Center Settings → Macro Settings. First, one rule.

Only enable macros from a source you trust. Macros are code — they can automate Excel, and they can also do harm. Excel disables them by default for exactly this reason. Never enable macros in an unexpected email attachment.

Enable macros for one trusted file (recommended)

When you open a workbook that contains macros, Excel shows a Security Warning bar with an Enable Content button. Clicking it trusts that specific file and lets its macros run. This is the safest approach — you're not changing anything globally.

Change the setting in the Trust Center

For a lasting change, go to File → Options → Trust Center → Trust Center Settings → Macro Settings. Choose "Disable VBA macros with notification" — this keeps you protected but prompts you per file, so you can enable the ones you trust. Avoid "Enable all macros," which removes the safety net entirely. Click OK, then reopen the workbook.

Show the Developer tab

To record or edit macros yourself, you'll want the Developer tab: File → Options → Customize Ribbon, tick Developer on the right, and click OK. It holds the Macros, Visual Basic and Record Macro buttons.

If macros are greyed out

Macros only run in macro-enabled files (the .xlsm format), not standard .xlsx workbooks. If the file was saved as .xlsx, its macros were stripped on save — you'd need the original .xlsm.

Automate the analysis, skip the macro

A lot of Excel macros just re-run the same report. Quiriz answers your questions in plain English and refreshes on new data — no VBA. Free to start.

Try Quiriz free →

Frequently asked questions

How do I enable macros for just one file?

Open the file and click Enable Content on the yellow warning bar at the top. That trusts only that workbook, which is safer than enabling all macros everywhere.

Why is the macro option greyed out or missing?

Macros only run in macro-enabled files (.xlsm or .xlsm-equivalent), not the standard .xlsx format. Also check File > Options > Trust Center > Macro Settings isn't set to disable macros without notification, and that the Developer tab is enabled if you're looking for the Macros button there.

How do I show the Developer tab?

Go to File > Options > Customize Ribbon, tick Developer in the right-hand list, and click OK. The Developer tab holds the Macros, Visual Basic and Record Macro buttons.

Is it safe to enable macros?

Only for files from a source you trust. Macros are code and can be malicious, which is why Excel disables them by default. Enable content per file rather than turning on all macros globally, and never enable macros in an unexpected attachment.