How to Enable Macros in Microsoft Office Without the Security Block

Macros can make a Word, Excel, PowerPoint, Access, Outlook, or Visio file work the way its creator intended. The confusing part is that Microsoft uses different macro blocks depending on where the file came from.

If you trust the file, the right fix is simple once you match the warning on screen. Start with the yellow bar, handle downloaded files separately, then adjust app settings only when you need a broader change.

1. Enable macros from the yellow security bar

Use this when the desktop Office app shows a yellow Security Warning message bar. This is the one-file path for a trusted document when your Office settings allow it.

1. 1.Open the file in the desktop Office app.
2. 2.On the yellow Security Warning message bar, select Enable Content.
3. 3.In the Security Warning dialog, select Yes.

That makes the document trusted. Do not use this step for the red SECURITY RISK banner on downloaded internet files, because that banner does not offer Enable Content.

2. Unblock a downloaded macro file in Windows

1. 1.Close the Office file.
2. 2.Open File Explorer.
3. 3.Go to the folder where the file is saved.
4. 4.Right-click the file and choose Properties.
5. 5.On the General tab, select Unblock.
6. 6.Select OK.
7. 7.Reopen the file in the desktop Office app.

This is the current fix for a trusted Office file that Windows marked as coming from the internet, such as a browser download or email attachment. On some network shares, the Unblock checkbox does not appear. For a single trusted local file, PowerShell does the same job: open PowerShell, run Unblock-File -Path "C:\Path\To\File.xlsm", then reopen the file.

3. Change macro settings in one Windows Office app

Use this when you want Word, Excel, PowerPoint, Access, Outlook, or Visio to handle macros differently by default. These settings are per app, so changing Word does not change Excel.

In the Office app you want to change, go to File > Options > Trust Center > Trust Center Settings > Macro Settings, choose one macro option, then select OK.

The choices are Disable all macros without notification, Disable all macros with notification, Disable all macros except digitally signed macros, and Enable all macros. In Excel, the labels use VBA macros wording. Microsoft labels Enable all macros as not recommended because potentially dangerous code can run.

4. Open Excel macro security from Developer

1. 1.Open Excel.
2. 2.Select Developer.
3. 3.Select Macro Security.
4. 4.In Macro Settings, choose the macro option you want.
5. 5.Select OK.

Excel has a shorter route to the same Trust Center page. It is useful when you already have the Developer tab turned on. This shortcut does not override a red internet-file block or an admin policy. It only opens the same macro settings screen inside Excel.

5. Turn on macros in Microsoft 365 for Mac

On Mac, macro controls live in the app preferences for Word, Excel, and PowerPoint. Microsoft says the default is Disable all macros with notification.

Open Word, Excel, or PowerPoint, then use the app menu to select Preferences > Security > Enable all macros.

To get a prompt each time instead, choose Disable all macros with notification. To block macros without prompts, choose Disable all macros without notification.

6. Open OneDrive SharePoint and Teams files in the desktop app

Do not download OneDrive, SharePoint, or Teams channel files first.

For files stored there, open the file from the OneDrive website or SharePoint site, then select Open in Desktop App. Microsoft says that path prevents the file from getting Mark of the Web. If you already downloaded the file locally, use File Explorer > Properties > General > Unblock > OK.

For a trusted macro file sent by email, save it to OneDrive before opening it. You can also save it to the hard drive and use the same Unblock step.

7. Trust a folder for repeat macro files

A Trusted Location is for files you truly rely on, not as a catch-all download folder.

1. 1.Open your Microsoft 365 app.
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.
10. 10.Select OK until all windows are closed.
11. 11.Put trusted macro files in that folder.

Office files in that folder open with macros enabled because Trust Center checks are skipped. Network Trusted Locations are possible, but Microsoft does not recommend them.

8. Trust a signed macro publisher

1. 1.Open the file.
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.

If a macro or add-in is digitally signed and you trust the publisher, Office lets you trust that publisher from the security options. First unblock the file if Windows marked it as coming from the internet. That trusts all code signed with that certificate as a Windows trusted publisher. For a one-time run, select Enable content for this session instead; the warning returns after you close and reopen the file.

9. Stop when an admin policy blocks macros

On a managed Microsoft 365 device, your organization can control macros with Cloud Policy, Intune, or Group Policy. Those policies can block internet macros or set macro notification behavior for Office apps. These macro policies apply to Microsoft 365 Apps for enterprise; Microsoft 365 Apps for business does not support them.

When policy is in charge, normal Office settings do not change the result. Use your organization's approved process for that file.

Frequently Asked Questions

Why do I see a red SECURITY RISK banner instead of Enable Content?

The file is marked as coming from the internet. Current Office apps on Windows block those macros by default, so the working options are Unblock in Windows, PowerShell Unblock-File, a Trusted Location, a trusted site or local intranet zone, or Open in Desktop App for OneDrive and SharePoint files.

Can I enable VBA macros in Excel for the web?

No. Excel for the web can open and edit some workbooks that contain VBA macros, but it cannot create, run, or edit VBA macros. Use Open in Desktop App.

Do I need to change macro settings in every Office app?

Yes, when you want the same behavior across apps. Trust Center macro settings are per app, so Word, Excel, PowerPoint, Access, Outlook, and Visio each keep their own setting.

Can Excel 4.0 macros still run?

Yes. In Excel desktop, go to File > Options > Trust Center > Trust Center Settings > Macro Settings, select Enable Excel 4.0 macros when VBA macros are enabled, then use a VBA macro setting that allows macros. You may also need to allow the file type: in Trust Center Settings go to File Block Settings, under File Type select Excel 4 MacroSheets, make sure Open is selected, set the open behavior to Open selected file types in Protected View and allow editing, then select OK twice.