How to Enable Macros in Excel

Excel is blocking your macros. You open a workbook, see a security warning, and the button you expected is either buried in Trust Center or missing completely.

You can enable macros in Excel the current way, whether the file is already trusted, downloaded from the internet, opened on a Mac, or stuck in Excel for the web.

1. Use the Security Warning First

Open the workbook in the Excel desktop app, then select Enable Content from the Security Warning Message Bar. When Excel asks whether you want to make the file trusted, select Yes.

That enables macros for that one workbook when Excel shows the normal macro warning. Use it only for files from a source you trust.

2. Fix the SECURITY RISK Banner on Downloaded Files

1. 1.Close the workbook in Excel.
2. 2.Open File Explorer.
3. 3.Find the workbook file.
4. 4.Right-click the file and select Properties.
5. 5.On the General tab, select Unblock.
6. 6.Select Apply.
7. 7.Select OK.
8. 8.Reopen the workbook in the Excel desktop app.

Downloaded workbooks on Windows carry an internet mark. Current Office blocks VBA macros in those files with a SECURITY RISK banner, so the older Enable Content shortcut does not apply there.

If your organization blocks internet macros by policy, this setting stays blocked until an admin approves the file, publisher, location, or macro policy.

3. Change Macro Settings in Excel for Windows

Use this when you want Excel to warn you about macros or allow signed macros by default.

1. 1.Open Excel.
2. 2.Select File.
3. 3.Select Options.
4. 4.Select Trust Center.
5. 5.Select Trust Center Settings.
6. 6.Select Macro Settings.
7. 7.Select Disable VBA macros with notification to block macros and still get alerts.
8. 8.Select Disable VBA macros except digitally signed macros to allow only signed macros.
9. 9.Select Enable VBA macros only when you intentionally want Excel to allow VBA macros.
10. 10.Select OK.

Microsoft labels Enable VBA macros as not recommended because potentially dangerous code runs under that setting. The Trust Center setting applies to Excel only. You can reach the same screen from Developer > Macro Security.

4. Use a Trusted Location for Regular Macro Workbooks

1. 1.Open Excel.
2. 2.Select File.
3. 3.Select Options.
4. 4.Select Trust Center.
5. 5.Select Trust Center Settings.
6. 6.Select Trusted Locations.
7. 7.Select Add new location.
8. 8.Select Browse.
9. 9.Choose the folder for trusted macro workbooks.
10. 10.Select OK.
11. 11.Select OK until all Trust Center windows close.
12. 12.Move or save the trusted macro workbook in that folder.
13. 13.Reopen the workbook in Excel.

A Trusted Location is a folder Excel treats as trusted. Keep this for workbooks you already trust and use it sparingly. Microsoft does not recommend network Trusted Locations, and work or school policy can block them.

5. Trust a Signed Macro Publisher

Signed macros identify the publisher. When you trust that publisher, Excel trusts all code signed with that certificate.

1. 1.Open a signed workbook from the publisher.
2. 2.Select File.
3. 3.Select Info.
4. 4.In the Security Warning area, select Enable Content.
5. 5.Select Advanced Options.
6. 6.In Microsoft Office Security Options, select Trust all documents from this publisher.

For personal testing, sign the macro project from Developer > Visual Basic > Tools > Digital Signature, select a certificate, then select OK. Self-signed certificates are trusted only on machines where that certificate is added to the trusted store.

6. Enable Macros in Excel for Mac

1. 1.Open Excel for Mac.
2. 2.Select Excel.
3. 3.Select Preferences.
4. 4.Select Security.
5. 5.Select Disable all macros with notification to get prompted when a workbook contains macros.
6. 6.Select Enable all macros to allow all macros.

Excel for Mac handles macro security from Excel preferences, not the Windows Trust Center. Microsoft lists Disable all macros with notification as the default. Managed Macs can have this preference locked by a configuration profile.

7. Open Excel for the Web Files in the Desktop App

Excel for the web opens and edits many workbooks that contain macros, but it does not create, run, or edit VBA macros in the browser.

1. 1.Open the workbook in Excel for the web.
2. 2.Above the ribbon, select Open in Desktop App.
3. 3.Use the Excel desktop app to view, edit, run, or enable macros.

There is no browser-only Excel setting that enables VBA macros.

8. Check With Your Admin on a Work or School Computer

Managed Windows and Mac devices can block macro settings, Trusted Locations, internet macros, and Office macro preferences. When policy controls those settings, Excel disables the controls or overrides your choice.

Send your admin the workbook source, the exact warning text, and whether you use Windows, Mac, or Excel for the web. They can approve the file, publisher, Trusted Location, or macro policy for your device.

Frequently Asked Questions

What file type do I need for Excel macros?

The research here covers macro-enabled workbooks and VBA macro behavior in Excel desktop. Excel for the web opens many macro-containing workbooks, but VBA macro creation, editing, running, and enabling happens in the desktop app.

What is the difference between a Trusted Document and a Trusted Location?

A Trusted Document is one workbook you approve from Excel's security warning. A Trusted Location is a folder where Excel treats files as trusted after you add that folder in Trust Center.

Can I enable old Excel 4.0 macros the same way as VBA macros?

No. Excel 4.0, or XLM, macros are legacy macro sheets with separate Trust Center and File Block settings. They are not the normal VBA macro flow covered in the main steps.

What does Trust access to the VBA project object model do?

It allows programmatic access to the VBA project object model. It does not enable normal macro execution, so it is not the setting to use when a workbook's macros are blocked.