How to enable macros in Excel (Windows & Mac)

Macros are blocked by default in Excel because they can run code that affects your files. If your trusted spreadsheet needs macros, you can enable them safely using one of the options below. The quickest fixes are allowing macros for the current file, adding a trusted location, or changing Trust Center settings when you understand the risks.

Before you start

• Save a backup of the workbook.
• Enable macros only from sources you trust.
• Keep antivirus on and avoid lowering protections globally unless necessary.

1) Enable macros for a single file you just opened (Security Warning bar)

1. Open the workbook in Excel.
2. If you see a yellow bar that says macros are disabled, select Enable Content.
3. Save and reopen to confirm the warning no longer appears.

2) Unblock files downloaded from the internet (Windows)

1. Close the workbook.
2. In File Explorer, right-click the file and choose Properties.
3. On the General tab, check Unblock then select OK.
4. Reopen the workbook and choose Enable Content if prompted.

3) Trust a folder so everything inside can run macros

1. In Excel, go to File > Options > Trust Center > Trust Center Settings.
2. Choose Trusted Locations > Add new location.
3. Browse to a folder you control, check Subfolders of this location are also trusted if needed, then select OK.
4. Move your macro-enabled files (.xlsm, .xlam) into that folder and reopen them.

4) Allow macros for this workbook type via Trust Center

1. File > Options > Trust Center > Trust Center Settings.
2. Select Macro Settings.
3. Recommended: choose Disable all macros with notification. This blocks macros by default but lets you enable them per file via the yellow bar.
4. If you must allow macros broadly, choose Disable all macros except digitally signed macros or Enable VBA macros (least safe). Select OK.

5) Use a digital signature to avoid prompts for your own macros

1. Obtain or create a code-signing certificate.
2. Sign your VBA project from the VBA Editor (Alt+F11) using Tools > Digital Signature.
3. With Trust Center set to Disable all macros except digitally signed macros, your signed workbooks will run without prompts while unsigned ones remain blocked.

6) Enable macros in Excel for Mac

1. Open the workbook. If you see a security prompt, select Enable Macros for this workbook.
2. To adjust defaults: Excel > Settings > Security & Privacy.
3. Choose the macro setting that fits your policy. For safer behavior, keep “Disable all macros with notification” and enable per file when needed.
4. To trust a folder, store files in your user Documents path and keep Gatekeeper warnings off by avoiding downloads from unknown sources.

7) Check file format and location

• Save macro files as .xlsm or .xlam. A standard .xlsx will remove VBA.
• Avoid network shares or cloud folders that strip Alternate Data Streams on Windows. If issues persist, copy the file to a local trusted folder.

8) If the Enable Content bar doesn’t appear

• Confirm there’s actual VBA: press Alt+F11 to see modules.
• Make sure Protected View isn’t blocking the file: File > Options > Trust Center > Trust Center Settings > Protected View. If a Protected View banner shows, select Enable Editing first, then Enable Content.
• Verify your organization’s policy isn’t enforcing stricter settings via Group Policy or a management profile.

Tips - Excel macro safety and performance

• Keep a clean “Trusted Macros” folder and use it only for vetted files.
• Prefer signed macros for team deployment.
• Document what each macro does inside the workbook (About sheet or comments) to speed up audits.
• Use versioned backups so you can roll back if a macro misfires.

FAQs

Are macros safe to use? Yes when they come from trusted sources and you keep “Disable with notification” enabled so you opt in per file.
Why did my macro disappear? It was likely saved as .xlsx, which strips VBA. Save as .xlsm or .xlam.
Can I enable macros for only one workbook permanently? Place it in a Trusted Location or sign it.
I don’t see Trust Center. You’re probably on a managed device where settings are controlled by your organization.

Summary

1. Open workbook and select Enable Content when prompted.
2. If downloaded, Unblock in file Properties on Windows.
3. Add a Trusted Location and store macro files there.
4. Adjust Macro Settings in Trust Center for broader control.
5. Sign your VBA to run without prompts on stricter policies.

Conclusion

Start with the safest path - keep macros disabled by default and enable them per workbook via the Security Warning bar. If you work with the same trusted files, add a dedicated Trusted Location or sign your code to reduce prompts. With these steps, you’ll run the macros you need while keeping the rest locked down.