Macros are how you automate stuff in Excel. Want to format a sheet the same way every time? Macro. Run a complex calculation across hundreds of rows? Macro. They're basically little programs that live inside your workbook.
Microsoft disables macros by default because they can also carry viruses. So if you got a file with macros and Excel refuses to run them, this is how you turn that block off safely.
Enable macros for the current file (one-time)
When you open a macro-enabled file, a yellow security bar usually shows at the top saying "Macros have been disabled". Click Enable Content. That's it. Macros run for this workbook from now on.
If the bar doesn't appear, the file might be in Protected View. Click Enable Editing first to exit Protected View, then the macro security bar pops up.
Enable macros permanently from the Trust Center
If you work with macros all day, the "Enable Content" click gets old. Change the default setting:
- Open Excel and go to File then Options
- Click Trust Center in the left sidebar
- Hit Trust Center Settings
- Pick Macro Settings
- Choose Enable VBA macros (not the recommended default)
- Click OK and restart Excel
Just know – this opens you up to risk. Any malicious macro in any Excel file you open will run automatically. Only do this if you trust where all your files come from.
Better option – trusted locations
Safer middle ground – tell Excel to trust files from specific folders only. Open Trust Center Settings again, click Trusted Locations, and add a folder where you keep your safe macro files. Anything inside that folder runs macros without prompts.
I have a folder on my desktop called "Excel Macros" that's trusted. Anything I drop in there runs clean. Everything outside still needs manual approval. Best of both worlds.
Show the Developer tab
To actually create or edit macros, you need the Developer tab visible. By default it's hidden. Right-click anywhere on the ribbon, pick Customize the Ribbon, and check the box next to Developer on the right side.
The Developer tab now appears in your ribbon with buttons for Record Macro, Visual Basic editor, and macro security. Most of what you need is right there.
Macros still blocked even after enabling?
Microsoft started blocking macros from internet-downloaded files extra hard in 2022. If the file came from email or a website, Excel marks it as "from the internet" and refuses to run macros even with your settings allowing them.
Fix – right-click the Excel file in File Explorer, pick Properties, and check the box that says Unblock at the bottom. Hit Apply. Now Excel treats it as a local file and your macro settings work normally.
Got a specific macro error? Drop the message in the comments and I'll help you debug it.