How to get macros on ?

Save the Excel file locally, close Excel, then right-click the file in File Explorer and select Properties > General > Unblock > Apply > OK before reopening it; changing Excel’s general macro setting does not remove this untrusted-source block.^1^

Only do this after verifying that the workbook and its macros are safe.

For one downloaded or emailed workbook

1. In Excel, select File > Save As and save the workbook to a local folder such as Documents.
2. Close Excel completely.
3. In File Explorer, right-click the saved .xlsm file and select Properties.
4. On the General tab, select Unblock, then Apply > OK.
5. Reopen the workbook.

Windows adds origin information—called Mark of the Web—to files obtained from email, browsers, or other untrusted locations. Removing it from a trusted file allows Office to evaluate and run its macros normally.^2^

Since the Trust Center and other general internet instructions have not fixed the issue, use the matching location-specific branch below rather than enabling all VBA macros.

If there is no Unblock checkbox

The workbook is likely being opened from a network or cloud location where per-file unblocking is unavailable or ineffective.

Local folder containing multiple approved workbooks

In Excel:

1. Select File > Options > Trust Center > Trust Center Settings.
2. Select Trusted Locations > Add new location.
3. Browse to a dedicated, access-controlled folder.
4. Select OK, move the approved workbook into that folder, and reopen it.

Every workbook placed there can run active content, so do not use Downloads or another folder where untrusted files arrive.

Company network share

If everyone opens the workbook from the same internal server, ask IT to designate that server as a Trusted Site or place an intranet server in the Local intranet zone. For a direct test on one managed PC:

1. Open Windows search and enter Internet Options.
2. Select Security > Trusted sites > Sites.
3. Add the exact server or site hosting the workbook.
4. Close and reopen Excel.

Network shares accessed by IP address can be classified as Internet-zone locations, causing macros to remain blocked. Microsoft recommends controlling who can write files to any trusted location.^2^

SharePoint, OneDrive, or Teams

Do not download the workbook through the browser. Open it on the SharePoint or OneDrive website and select Open in Desktop App, or access it through the OneDrive sync client. Files opened by those methods do not receive Mark of the Web in the documented scenarios.^2^

If all office members are affected

Have the Microsoft 365 or Windows administrator deploy a controlled organization-wide configuration rather than asking each user to weaken macro security:

• Approve a dedicated Trusted Location for the workbook.
• Assign the internal file server, SharePoint, or OneDrive domain to Trusted Sites through the Site to Zone Assignment List policy.
• Restrict write access to the approved location.
• For internally developed macros, sign them and deploy the trusted publisher certificate where appropriate.

If the warning instead says “Your administrator has restricted the use of macros in your organization,” it is an administrator policy block. Users cannot override that in Trust Center; the workbook must be moved to an IT-approved location or the administrator must change the applicable policy.^1^

Do not disable all macro protection. Office intentionally prevents active content from running automatically unless the document, location, or publisher is trusted.^3^

References

1. A potentially dangerous macro has been blocked
2. Macros from the internet are blocked by default in Office
3. Protect yourself from macro viruses