Enabling macros in Excel for Mac unlocks automated workflows and custom tools built with Visual Basic for Applications. This guide walks you through trusted steps so your spreadsheets run the code securely.
Before you adjust security settings, review the table below to understand how macro settings on Excel for Mac control code execution and file trust.
| Security Level | What It Does | Macro Access | When to Use |
|---|---|---|---|
| Disable All Macros | Prevents any macro from running | None | Default for untrusted files |
| Disable All Macros Except Digitally Signed | Runs only macros from trusted publishers | Signed macros only | Balanced security and usability |
| Enable All Macros | All macros run without restriction | All macros | Temporary local debugging |
| Trusted Locations | Files in these folders are allowed to run code | All macros in trusted folders | Regular automation work |
Open Security Settings on Mac
To change macro behavior, you first locate the right preferences inside the Excel app on your Mac.
Launch Excel and Access Preferences
Open Excel, then from the menu bar choose Excel followed by Preferences. This central panel controls workbook behavior and macro settings.
Enable Macros via Macro Security
The macro security page is where you pick how much automation Excel for Mac should allow on your machine.
Navigate to Macro Security
In Preferences, click Security under User Settings or Macro Settings. Adjust the slider or radio buttons to raise or lower macro access based on your risk tolerance.
Add Trusted Locations on Mac
Using trusted locations is a practical way to allow specific folders to run macros without lowering global security for every file.
Create a Trusted Folder
In Security settings, add a folder you frequently use for personal projects. Excel will automatically trust macros in workbooks stored there after you confirm the path.
Adjust Macro Settings for Current Workbook
Sometimes you want macros enabled only for the file you are actively editing, without changing global preferences.
Enable Content for This Session
When a workbook with macros opens, click Enable Content on the yellow banner at the top. This temporary allowance expires when you close the file unless you save it as a trusted template.
Quick Setup Recommendations
- Keep global security at Disable All Macros Except Digitally Signed for daily use
- Add a dedicated Trusted Location for your personal automation projects
- Test new macros in a copy of the workbook before enabling content
- Use digital signatures for production macros shared across teams
- Remove trusted locations that are no longer needed to reduce risk
FAQ
Reader questions
Why are my macros disabled even though I enabled them in preferences?
The workbook might be opened in Protected View or located outside a trusted location. Move the file to a trusted folder or click Enable Content on the warning bar to run the code.
Can I allow macros for just one Excel file on Mac?
Not with a single-click global rule, but you can add the file’s folder to Trusted Locations or click Enable Content each time you open that specific workbook.
What happens if I choose to disable all macros except digitally signed?
Excel runs only macros that come with a valid digital certificate from a publisher you have marked as trusted. All other code stays inactive.
Is it safe to enable all macros on Mac for quick testing?
Enable All Macros only on local test files you control. On shared machines or unknown workbooks, use the more restrictive options to avoid malicious code execution.