Unable to enable macros on excel file

Kris Rooneem 0 Reputation points
2026-11-19T20:03:39.1166667+00:00

I have a security risk message that says, "Microsoft has blocked macros from running because the source of this file is untrusted. And when attempting to follow the directions provided by Microsoft for this situation (https://support.microsoft.com/en-us/office/vba/a-potentially-dangerous-macro-has-been-blocked) - see first screenshot, I don't see any option for unblocking the macros (see second screenshot). User's imageUser's image

Selecting the advanced button and selecting the security tab also do not reveal anything that would allow me to declare this file as trusted so that macros can be enabled.

Is there another way to achieve the desired outcome?

Microsoft 365 and Office | Excel | For business | Windows
0 comments No comments

2 answers

Sort by: Newest
  1. Deogratias 190 Reputation points Independent Advisor
    2026-11-19T21:19:19.14+00:00

    Hello Kris

    Thank you for confirming that you completed all steps in the Microsoft support article.

    Please check whether a digital certificate is available on the device and assign it to a file by following the steps below

    Open the Workbook and go to File > Info > Protect Document > Add a Digital Signature. Select the appropriate certificate, click Sign, reopen the file, and test again.

    If the issue persists, please contact your Microsoft 365 administrator to check whether an organizational policy is blocking macros. If necessary, the administrator should raise a support ticket with Microsoft.

    I hope I can find a satisfactory solution to your problem. If you have any additional questions or concerns, please don’t hesitate to reach out

    Kind regards,

    Was this answer helpful?

    0 comments No comments

  2. AI answer

    2026-11-19T20:03:57.1833333+00:00

    Yes. If the Unblock checkbox is not present, use one of these supported approaches for a file that is trusted:

    1. Make the file a trusted document
      • Open the workbook in Excel.
      • If a yellow Security Warning bar appears, select Enable Content.
      • In the Security Warning dialog, select Yes to make the document trusted.
      • This enables macros for that document.
    2. Add the folder as a Trusted Location
      • In Excel, go to File > Options > Trust Center > Trust Center Settings.
      • Select Trusted Locations.
      • Add the folder that contains the workbook.
      • If trusted locations are disabled, clear Disable all Trusted Locations.
      • Reopen the workbook.
    3. If the file is on OneDrive or SharePoint
      • Open it by using Open in Desktop App.
      • If it was downloaded locally before opening, remove the Mark of the Web from the local copy using an individual-file unblock method when available.
      • Another supported option is to designate the location as a Trusted site.
    4. If the file is on a network share
      • Add the location to Trusted Locations.
      • If needed, allow documents on the network to be trusted in Trust Center settings.
      • Microsoft also documents adding the location to the Local intranet zone or designating it as a Trusted site.
    5. Check macro settings if the file still cannot be trusted
      • Go to File > Options > Trust Center > Trust Center Settings > Macro Settings.
      • Use Disable all macros with notification if the goal is to get the Enable Content prompt.
      • If a stricter policy such as Disable all macros without notification is applied, the file might not be able to become a trusted document.

    Important: Trusting a location allows macros in all files stored there to run. Only use this for folders and files from trusted sources.


    AI-generated content may be incorrect. Read our transparency notes for more information.

    Was this answer helpful?

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.