MS Excel
0 Guide

How to Enable Macros in Excel

This is an Arcade

Need to enable macros in Excel? Follow these Mac and Windows steps to activate macros through Trust Center or Security settings and unlock automation tools.

1. Open your Excel workbook

Launch Excel and open the file that requires macros for automation or scripting.‍

2. Check for a security warning below the ribbon

If the workbook contains macros, Excel may display a yellow bar below the ribbon. Click Enable Content or Enable Macros to activate them.

3. Open Excel’s settings or preferences

On Windows, click the File tab, then select Options. On Mac, click Excel in the top menu bar, then select Preferences.

4. Go to Trust Center or Security settings

On Windows, select Trust Center, then click Trust Center Settings. On Mac, under the Sharing and Privacy section, click Security.

5. Adjust Macro Settings

Choose your preferred setting — such as Enable all macros or Disable all macros with notification. For safety, enabling with notification is recommended.

6. Click OK and restart Excel if needed

Apply your settings and restart Excel if prompted for the changes to take effect.

MS Excel
0 Guide

Ready to create quick,
interactive product demos?

Sign up
– it's free
{ "@context": "https://schema.org", "@type": "HowTo", "name": "How to Enable Macros in Excel", "description": "Need to enable macros in Excel? Follow these Mac and Windows steps to activate macros through Trust Center or Security settings and unlock automation tools.", "step": [ { "@type": "HowToStep", "name": "Open your Excel workbook", "text": "Launch Excel and open the file that requires macros for automation or scripting." }, { "@type": "HowToStep", "name": "Check for a security warning below the ribbon", "text": "If the workbook contains macros, Excel may display a yellow bar below the ribbon. Click Enable Content or Enable Macros to activate them." }, { "@type": "HowToStep", "name": "Open Excel’s settings or preferences", "text": "On Windows, click the File tab, then select Options. On Mac, click Excel in the top menu bar, then select Preferences." }, { "@type": "HowToStep", "name": "Go to Trust Center or Security settings", "text": "On Windows, select Trust Center, then click Trust Center Settings. On Mac, under the Sharing and Privacy section, click Security." }, { "@type": "HowToStep", "name": "Adjust Macro Settings", "text": "Choose your preferred setting — such as Enable all macros or Disable all macros with notification. For safety, enabling with notification is recommended." }, { "@type": "HowToStep", "name": "Click OK and restart Excel if needed", "text": "Apply your settings and restart Excel if prompted for the changes to take effect." } ] }