How do unblock macros from a source I trust on an excel sheet, that microsoft blocked.

Macros in Excel files from the internet are now blocked by default, even if the source is trusted, unless the file itself is unblocked or stored in a trusted zone/location. Since the site is already added to the Trust Center and the file’s Properties were adjusted, use the following checks and methods that are specifically supported:

1. Confirm the file is fully unblocked (Mark of the Web removed)
   1. Save the workbook to a local drive (or OneDrive/SharePoint sync folder).
   2. In Windows File Explorer, right‑click the file > Properties.
   3. On the General tab, at the bottom, look for the Security section.
   4. If the Unblock checkbox is visible, select Unblock, then select OK.
      • This removes the Mark of the Web (ZoneId) so macros can run by default, assuming no policy or Trust Center setting is blocking them.
   5. Reopen the workbook in Excel and test the macros.
   If the Unblock checkbox is not present or has no effect (common on some network shares considered Internet zone), use one of the approaches below.
2. Use PowerShell to remove Mark of the Web (ZoneId) If allowed in the environment, the Mark of the Web can be removed via PowerShell, which is equivalent to using the Unblock checkbox:

      Unblock-File -Path "C:\Path\To\YourFile.xlsm"
   

   Removing the ZoneId value allows VBA macros to run by default, provided no macro policy or Trust Center setting blocks them.
3. Check the zone of the location (especially for network shares) Even if the site or share is trusted, if Windows treats it as Internet or Restricted sites, macros will still be blocked.
   • On the client, open Control Panel > Internet Options > Security.
   • Verify whether the site or network path is in Trusted sites or Local intranet, not Internet or Restricted sites.
   • If files are on a network share:
     • Prefer saving them to a location already in Local intranet, or
     • Add the share to Local intranet (recommended over adding new Trusted sites broadly).
4. Use a trusted location instead of only a trusted site For files on internal file servers or trusted websites:
   • Ensure the location is configured as a Trusted site or in Local intranet so that macros from those locations are not blocked.
   • If the share is still treated as Internet zone, moving the file to a location that is already in Local intranet or Trusted sites is more reliable than only adjusting the file’s properties.
5. Understand interaction with Trusted Documents
   • Previously, selecting Enable content on the security warning banner made the file a Trusted Document, and macros continued to run.
   • With the new behavior, a SECURITY RISK banner appears for internet files and does not offer Enable content.
   • The only supported way to allow macros in that case is to remove Mark of the Web (Unblock in Properties or Unblock-File) and ensure no macro policies are blocking them.

If, after confirming the file is unblocked and the location is in Local intranet or Trusted sites, macros are still blocked, a higher‑level macro policy (for example, “Block macros from running in Office files from the Internet”) may be enforced by the organization, which will override local Trust Center and file settings.

References:

• Macros from the internet are blocked by default in Office
• Block suspicious macros in Office on Windows 10 S
• BLOCKED errors are returned when a required resource can't be accessed. See below for specific cases.