Excel macros are small automation scripts written in VBA that let you record, repeat and customize tasks inside a spreadsheet. You can use them to format reports, sort huge datasets, generate invoices or run calculations with one click. But sometimes you want to enable macros for many reasons, e.g., a downloaded template needs them, your boss sent you a macro-enabled file or you are trying to build your own automation.
Quick fix. Excel disables macros by default for security. One trip to the settings and you can enable them. Just be careful which files you trust.
This easy guide will help you enable macros in Excel by showing you the Trust Center setting, explaining the four security levels, and helping you avoid the malware risk that comes with running unknown macros.
Why Excel Disables Macros by Default
Real quick. Macros can do almost anything. Read your files, send emails, modify system settings. That is great when you wrote them. Dangerous when the file came from a sketchy source.
So Microsoft blocks them by default and asks you each time. Smart move. Just annoying when you trust the file.
Method 1: Enable Macros for One File (Safer)
This is the recommended approach. Enable macros only for the specific file you trust, leave the rest blocked.
- Open the Excel file. You will see a SECURITY WARNING bar at the top.
- It says “Macros have been disabled.”
- Click Enable Content.
- Macros work for this file only and this session.
Done. Excel remembers your choice for this specific file going forward.
Method 2: Enable All Macros Permanently (Riskier)
Skip this unless you know what you are doing. Enabling all macros means any Excel file you open can run code automatically. Real talk, this is how most macro malware spreads.
If you still want it:
- In Excel, click File > Options.
- Click Trust Center in the left sidebar.
- Click Trust Center Settings.
- Click Macro Settings in the left sidebar.
- Choose your security level (see next section).
- Click OK twice to save.
The Four Macro Security Levels Explained
Excel has four macro settings. Pick based on how careful you are with files.
- Disable all macros without notification – the safest. Macros never run, no warnings. Use if you never need macros.
- Disable all macros with notification – the default. You see the SECURITY WARNING bar and can click Enable Content. Recommended for most users.
- Disable all macros except digitally signed macros – only signed macros from trusted publishers run automatically. Good middle ground.
- Enable all macros (not recommended) – every macro runs automatically. Skip this unless you are a developer.
Personally I keep mine on the second option. One click to enable when I need it, blocked otherwise.
Method 3: Set Up a Trusted Location
Smarter approach. Set up a folder on your computer as Trusted. Excel runs macros automatically for any file in that folder, blocks them everywhere else.
- Go to File > Options > Trust Center > Trust Center Settings.
- Click Trusted Locations.
- Click Add new location.
- Browse to your trusted folder, add a description and click OK.
- Save files with macros only in that folder.
Now your own macros run instantly without the warning bar. Random downloads still get blocked.
What If Macros Still Will Not Run
You enabled them but the macro still does not work. Common causes:
- The file is not a macro-enabled format. Save it as .xlsm or .xlsb, not .xlsx.
- Excel is in Protected View. Click Enable Editing first.
- The file came from the internet and Windows blocked it. Right-click the file > Properties > check Unblock > OK.
- Your company has Group Policy disabling macros entirely. Talk to your IT admin.
If none of those, the macro itself might be broken. Open the VBA editor (Alt + F11) and look for syntax errors.
My Honest Opinion
Most macro-malware in the wild targets users who set Enable all macros. Do not do that. Real talk, just leave Excel on default settings.
When you trust a file, click Enable Content once and you are good. When you do not trust the source, leave it disabled. That covers 99% of cases without putting your computer at risk.
Final Thoughts
Enabling macros in Excel is one click for trusted files and a couple of settings clicks if you want them permanently on. Just remember macros are powerful, so only enable them for files you trust.
Click Enable Content for trusted files. Trusted Locations folder for your own work. Avoid Enable all macros unless you are a developer.
Also, if you follow our steps and still face difficulties enabling macros in Excel, seek help from Microsoft Support or leave a comment in the comment section of our blog.