How to Enable Macros in Excel: Security Settings You Must Adjust First

Enabling macros in Excel unlocks automation that can save you hours of repetitive work—but only after you adjust the security settings that block them by default. 💡 I remember the first time I accidentally disabled macros in a spreadsheet that automated payroll calculations, and the panic of realizing I'd just undone weeks of work.

The fix is simpler than you'd think, but the security warnings can feel intimidating if you're not prepared.

Here's the thing—Excel's security settings exist for good reason. They prevent malicious code from running automatically, but they also block legitimate macros unless you explicitly allow them. The process takes about two minutes once you know where to look, and I'll walk you through it step by step.

No special tools or IT permissions required—just your own Excel installation and a few clicks in the right places.

Once you've adjusted these settings, you'll be able to run macros stored in your workbook or add-ins without constant warnings popping up. That means your custom functions, data imports, and automated reports will run smoothly every time you open the file.

The difference between struggling with manual work and having Excel handle the heavy lifting is just a few security tweaks away.

This works for Excel 2016 and later on Windows or Mac, though the exact path to the security settings might vary slightly depending on your version. We'll cover both so you can follow along no matter which edition you're using. Let's get those macros working for you!

What you need

Step-by-step instructions for enabling macros in Excel

Here's the exact procedure I use to safely activate macros in Excel without triggering security warnings.

Launch Excel from your Start menu or desktop shortcut. I always open a new blank workbook first to avoid accidentally modifying existing files. Once Excel loads, click the File tab in the top-left corner—this opens the backstage view where all settings live.

In the left-hand menu, scroll down and select Options. This brings up the Excel Options dialog box. Look for Trust Center in the list of categories on the left side and click it. The Trust Center is where Excel's security settings are managed, including macro permissions.

Within the Trust Center window, click the Trust Center Settings button. This opens a new dialog box with several security options. Select Macro Settings from the left-hand menu—this is where you'll adjust permissions for macros.

Here's the critical part: select the radio button for Enable all macros if you trust the source of your workbook completely. This is the most permissive setting and will allow all macros to run without warnings. For a middle ground, choose Disable all macros with notification—this will prompt you before running any macros, giving you control over each one.

After selecting your preferred macro setting, click OK to close the Trust Center Settings dialog. You'll return to the Trust Center window—click OK again to save these changes and exit. Close the Excel Options dialog as well.

To verify your changes, open a workbook that contains macros (like a template with automation). Try running a macro—if you see a security warning, you're still in a restricted mode. If macros run automatically without warnings, your settings are correctly applied. For the Disable with notification setting, you should see a prompt asking whether to enable macros when you attempt to run one.

If you're working with advanced macros that require access to the VBA project, you'll need to take an additional step. Return to the Trust Center Settings by clicking File > Options > Trust Center > Trust Center Settings > Macro Settings again.

At the bottom of the Macro Settings window, check the box for Trust access to the VBA project object model. This is necessary for macros that interact with the VBA editor or modify project properties. Click OK to save, then restart Excel for these changes to take full effect. This step is often overlooked but critical for developers.

Tips & tricks for smooth macro enabling in Excel

Here's what I've learned from years of enabling macros without security headaches—and how to avoid the most common pitfalls.

Backup First: Before making any changes in Step 1, save a copy of your workbook with a different name. I've seen too many people accidentally overwrite their original files when testing macros. Excel's "Save As" feature is your safety net—use it before diving into Trust Center settings.

Security Settings Aren't Permanent: The changes you make in Step 2 only apply to your current Excel session. If you close and reopen Excel, you'll need to re-enable macros unless you're using the "Enable all macros" option. For frequent macro users, I recommend setting up a desktop shortcut with the macro-enabled setting already configured.

Verify with a Test Macro: After completing Step 3, don't just assume it worked. Open a simple workbook with a basic macro (like one that changes cell color) and test it. The verification step is where most people realize their settings didn't stick. I keep a tiny test file just for this purpose—it's saved me countless headaches.

Optional VBA Access Tip: If you're working with advanced macros in Step 4, remember that checking "Trust access to the VBA project object model" requires a restart. Don't forget this crucial step—many developers miss it and wonder why their VBA editor isn't working properly. I always make a note in my calendar to restart after enabling this setting.

Frequently asked questions

Got questions about enabling macros in Excel? You’re not alone! Here are some of the most common queries—along with clear answers to help you get started safely and smoothly.

Wrapping up and next steps

Enabling macros in Excel unlocks powerful automation—but always prioritize security by adjusting settings thoughtfully. Whether you’re automating repetitive tasks or leveraging advanced functions, the key is balancing convenience with trustworthy sources.

Now that you’re equipped with the know-how, take the next step: explore macro programming or dive into creating your first custom script!

🚀 Pro Tip: Start small—test macros in a safe copy of your workbook before applying them to critical data.