How To Enable Macros in Excel | Turn On Trusted VBA Safely

Macros can save you hours. They can also cause real damage when they come from the wrong place. That’s why Excel keeps them locked down until you make a choice.

This walkthrough shows exactly how to enable macros, what each setting means, and how to do it without turning your laptop into a playground for malicious code. You’ll see the safe “per-file” way, the settings-based way, and the common gotchas that make macros stay blocked.

What “Enable Macros” Really Means In Excel

In Excel, “macros” usually means VBA code embedded in a workbook, add-in, or template. When macros run, they can edit data, move files, call other programs, and change your Excel setup.

Excel uses a few layers to decide whether code runs: the file type (like .xlsm), where the file came from, whether you’ve trusted it before, and your Trust Center settings.

Before You Flip Any Settings, Check The File Type And The Source

Start with two quick checks. They prevent most “Why is this still blocked?” headaches.

• Confirm it’s macro-enabled: .xlsm, .xltm, or .xlam are the common macro formats. A plain .xlsx can’t store VBA macros.
• Think about where it came from: email attachments, downloaded ZIPs, and chat transfers are the riskiest. A workbook from your own shared drive is usually a different story.

If you didn’t expect a macro-enabled file, don’t enable anything yet. Open it, review the content, and verify who sent it.

Fastest Safe Method: Enable Macros For One Workbook

If your macro settings allow it, Excel may show a yellow message bar near the top of the sheet with a warning that macros are disabled.

When you trust the file, click the button to enable content for that workbook. This approach keeps your global settings tight while still letting you run the code you came for.

Microsoft describes the per-file enable flow and where those macro controls live in Office apps in its support documentation. Enable or disable macros in Microsoft 365 files.

How To Enable Macros in Excel For Trusted Workbooks

If you keep getting blocked, or you want a consistent rule for your machine, use the Trust Center. The exact labels vary a bit by Excel version, but the path is the same.

Windows: Change Macro Settings In Trust Center

1. Open Excel.
2. Click File > Options.
3. Select Trust Center.
4. Click Trust Center Settings.
5. Choose Macro Settings.
6. Select the option that matches your situation (details below), then click OK.

Close and reopen the workbook after you change settings, so Excel reevaluates it from a clean start.

Mac: Where Macro Settings Live

Excel for Mac also has macro security controls, though the menus don’t always mirror Windows. In many versions, you’ll find them under Excel preferences and security or privacy sections.

If you’re on Mac and don’t see a macro setting at all, check your Excel version and update Office. Some controls appear only in newer builds.

Why Downloaded Files Get Blocked Even When Your Settings Look Fine

In recent Office builds, files that come from the internet can be blocked at a deeper layer. Even if you pick a macro setting that normally allows a prompt, that downloaded workbook can stay locked until it’s trusted in a way Office accepts.

Microsoft explains this “internet macros” blocking behavior and why it exists in its security guidance. Macros from the internet are blocked by default in Office.

What this looks like in real life:

• You open a macro-enabled file you downloaded.
• You don’t get the usual “Enable Content” button, or clicking it doesn’t help.
• The macro stays disabled, and Excel may mention security risk or the file being blocked.

In that case, the fix is rarely “enable all macros.” It’s usually “trust this file or move it to a trusted place.”

Macro Settings Options And What They Actually Do

These are the choices you’ll see in the Trust Center. Pick the least-permissive setting that still lets you get work done. If you’re unsure, choose the option that shows a prompt and decide per file.

Trust Center Choice	What Excel Does	When It Fits
Disable all macros without notification	Blocks macros and shows no prompt	Locked-down PCs where macros should never run
Disable VBA macros with notification	Blocks macros, then shows a warning so you can allow per file	Best default for most people who only run known macros
Disable VBA macros except digitally signed macros	Runs signed macros from trusted publishers; blocks others	Teams using signed VBA in a controlled workflow
Enable VBA macros	Runs most VBA macros without prompting	Short-term testing in a controlled setup
Trust access to the VBA project object model	Allows code to programmatically edit VBA projects	Only when a vetted tool needs it; leave off otherwise
Trusted Documents (per-file trust)	Remembers a workbook you allowed, then permits macros again later	Great for recurring files you use often
Trusted Locations (folder trust)	Permits macros for files stored in specific folders	Shared team folders with tight permissions
Block macros from the internet	Prevents downloaded files from running macros until trusted safely	Leave on unless you have a strong reason and a controlled process

Two Safer Patterns That Beat “Enable All Macros”

Pattern 1: Use “Disable With Notification” And Allow Only Known Files

This is the sweet spot for most setups. You keep the default block in place, then allow macros only when you recognize the file and expected the behavior.

If you share spreadsheets with teammates, agree on a simple rule: macros run only in files stored in a shared folder everyone recognizes, not in random attachments.

Pattern 2: Put Macro Workbooks In A Trusted Folder With Locked Permissions

A trusted folder works best when you can control what lands in it. If anyone can drop files into that folder, it stops being trustworthy.

Use a folder where only you (or a small admin group) can write files. Store your macro-enabled templates and tools there. Open those files from that location, not from your Downloads folder.

Step-By-Step: Make A Workbook Trustworthy Without Loosening Everything

Step 1: Save A Copy To A Clean Location

If you got the file from email or a download, save a copy to a folder you control. Rename it to something you’ll recognize later. A clear filename reduces misclicks when you’re tired.

Step 2: Check The Macro Code If You Can

If you have access to the VBA editor, scan the modules for anything that looks off: hidden network calls, odd file writes, commands that run other programs, or code that triggers when the workbook opens.

You don’t need to understand every line. You’re looking for surprises. If it feels strange, stop and verify the source.

Step 3: Enable Content For That Workbook, Not Globally

Open the file. If you see the warning bar, enable content for that workbook. That’s the lowest-friction way to run your macro while keeping your overall macro posture strict.

Step 4: If It’s Still Blocked, Treat It Like An “Internet File”

When a workbook is tagged as coming from the internet, you may need to remove that block at the file level or move it into a location Office treats as trusted.

On Windows, one common place to check is the file’s properties in File Explorer. If Windows shows an unblock option on the General tab, applying it can change how Office treats the file the next time you open it.

Common Macro Prompts And What They Mean

Excel messages can look a bit different across versions, yet the meaning is usually consistent.

• “Macros have been disabled” with a button: Your settings allow you to choose per workbook. Enable only if you trust it.
• A red or stern warning with no enable button: The file is treated as high-risk, often because it came from the internet.
• No warning at all, macros still don’t run: The workbook may not contain macros, the code might be in an add-in you didn’t load, or the macro is failing at runtime.

When Macros Still Won’t Run: Quick Troubleshooting Checklist

Use this list in order. It’s faster than clicking around at random.

1. Confirm the file is .xlsm or .xlam and you’re not editing a .xlsx copy.
2. Close Excel completely and reopen it, then open the workbook again.
3. Check Trust Center macro settings and choose “Disable VBA macros with notification.”
4. If the file was downloaded, move it out of Downloads and try again.
5. If the macro is in an add-in, confirm the add-in is loaded.
6. Open the VBA editor and run the macro manually to see the exact error.
7. Check whether the macro depends on blocked external data connections.

Symptom	Likely Cause	Fix
No “Enable Content” button shows	Internet macro blocking or a stricter policy	Move file to a controlled folder, then trust it using safer methods
Macro runs on your PC, fails on a coworker’s	Different Trust Center settings or add-ins	Align macro settings, confirm add-ins, standardize file location
Buttons in the sheet do nothing	Macros disabled or controls not assigned	Enable macros for the file, then verify the button assignment
Macro starts, then errors out	Runtime error in VBA logic	Run from VBA editor to see the line that fails
Macro disappears after saving	Saved as .xlsx	Save as .xlsm and confirm the file type after saving
Macro works locally, fails from a network share	Network location not trusted	Use a trusted location with controlled permissions
Workbook opens read-only and macros don’t run	Protected view or file permissions	Save a local copy you own, then reopen and enable content

Safe Habits That Keep Macro Workflows Smooth

A good macro setup is less about one toggle and more about habits. These keep you productive without giving malware a free pass.

• Keep the default strict: Use the prompt-based macro setting, then allow per workbook.
• Standardize where macro files live: One folder for macro tools beats a pile of attachments.
• Name your files clearly: If you can’t tell what it is at a glance, you’re more likely to enable the wrong thing.
• Separate “test” from “daily work”: If you must relax settings, do it in a throwaway Excel session or a dedicated test machine, then switch back.
• Prefer signed macros in teams: If your org supports it, signed VBA cuts down on guesswork.

Wrap-Up: The Clean Way To Run Macros Without Opening The Floodgates

If you want macros to run and still sleep at night, stick to a simple rule: keep Excel set to block with a notification, then allow macros only for files you recognize and control.

When a downloaded workbook stays blocked, treat it as a trust issue, not a “turn everything on” problem. Use trusted documents or a locked-down folder, and you’ll spend more time getting results and less time fighting warnings.