Excel macros blocked with no Enable Content button

TLDR

For a downloaded workbook whose source and purpose you trust, use Unblock in its Windows file properties and reopen that file. You do not need to enable every Excel macro.
If Unblock is missing, first check that Properties belongs to the workbook rather than its folder. If the file is correct and Unblock is absent or ineffective, send IT its path, the Properties view, and the remaining warning to establish the approved copy and opening method.
To run a macro on figures entered in a browser, open the same workbook in installed Excel. If its button still fails there, give the supplier the remaining warning and file extension so they can check whether that copy supports the function you need.

If Excel says it blocked macros because the file’s source is untrusted, Windows file properties can provide a way to unblock that specific download. First establish that you trust the file and are allowed to run it. Organizational restrictions can still apply. The steps below concern downloaded macro workbooks in Microsoft 365 Excel for Windows.

A Microsoft Q&A user reported being unable to run a VBA project and unable to find Unblock. In a follow-up, they also mentioned a setting that allowed only digitally signed macros. The report illustrates why a missing control is insufficient to diagnose the problem: file properties and Excel’s macro settings need to be examined separately.

Enable Editing does not settle the macro warning

Protected View opens potentially unsafe documents with editing restricted. Enable Editing lets you leave that mode when you trust the document. Being able to change a cell does not establish that its VBA automation is allowed to run.

The familiar macro notification can offer Enable Content. An internet-source block instead presents a Security Risk message without that route. Instructions written for the first notification can therefore leave you searching for a button that is absent from the second.

What the message concerns	What to examine next
Protected View and editing	The document’s source and whether you need to edit it
Disabled macros with Enable Content available	Whether you trust this workbook’s code
Macros blocked because the source is untrusted	The downloaded file’s properties and location
Administrator restrictions	Your organization’s approved file or delivery location

Read the named component, too. An ActiveX warning concerns another kind of active content. A password prompt or a workbook that cannot open at all requires a different investigation from allowing VBA.

Unblock the particular file you intend to use

Confirm that you expected this workbook and understand the function its macros provide. A familiar company name in an email is insufficient by itself to establish the attachment’s origin. If you only need to read the figures, ask whether the supplier can provide an ordinary workbook or another suitable output without executable automation.

Microsoft’s single-file procedure uses File Explorer. For a known workbook that your organization permits:

Save the download in an approved local folder. Close the copy currently open in Excel.
Locate that saved file in File Explorer. Check its folder and extension, especially if you have several copies.
Right-click the file and open Properties.
On the General tab, select Unblock if it is present, then choose OK.
Reopen that same file. Read any remaining warning; if Excel offers Enable Content for the permitted workbook, you can authorize the required code.

You may not receive another Enable Content prompt. Existing trust decisions, macro settings, and policy can affect the next screen.

For example, unblocking a saved file called ExpenseTemplate.xlsm and then opening the email attachment again can send you back to a different copy. Open directly from the folder you just used. Treat a newly downloaded version as a new file to assess, even when the supplier has kept the same filename.

Once the warning is gone, follow the supplier’s instructions for the function you need. Suppose an approved template is meant to generate a separate report from entered figures. In a practice copy, use sample inputs and check where the report is saved and whether it contains the expected values. Opening the workbook successfully does not establish that its report-generation function worked. If the same button also sends email or updates shared records, obtain the supplier’s test procedure before using it with live data. Record which action failed so the supplier can reproduce that part of the workflow.

No Unblock checkbox: record where the file actually lives

Check the title of the Properties window. You may have opened the Downloads folder’s properties instead of the workbook’s. Select ExpenseTemplate.xlsm itself in File Explorer and open its properties. Changing the folder’s Read-only attribute is not the single-file unblocking procedure. The object to inspect is the workbook you saved in the previous section.

If the correct file has no Unblock checkbox, record that alongside Excel’s warning. Its absence alone does not establish that macros are permitted or that corporate policy caused the block. If you did apply Unblock, note the warning before and after reopening, along with the path of the reopened file. This tells IT whether the source-related warning remains or a different restriction, such as ActiveX or an administrator message, now needs attention.

Windows can attach an internet-origin marker called Mark of the Web to downloads. Network shares also have security-zone classifications. Microsoft’s explanation of internet macro blocking notes that Unblock can be ineffective when the share itself is in the Internet zone.

For a workbook opened from a company server, send IT the path you used, including the IP address if you connected that way. They can check how Windows classifies that location. A server used inside the company can still fall in the Internet zone, leaving its workbooks blocked despite changes to individual file properties. If you opened a local copy instead, give IT that copy’s folder path.

For SharePoint and OneDrive, a browser download can acquire an origin marker that direct opening through Open in Desktop App does not. Use the delivery method your organization approves. Opening in the desktop application does not cancel a separate corporate macro restriction.

If settings are unavailable, Microsoft’s macro-settings guidance identifies work or school management as a possible reason. Ask for an approved location or distribution copy. Also remember that disabling VBA without notification suppresses alerts; a vanished banner alone does not demonstrate successful execution.

The nearby setting for access to the VBA project object model serves code that manipulates the VBA environment. It is not the file-unblocking control. There is no reason to select every VBA-related checkbox to make one downloaded template work.

Trusting a folder includes files added later

A Trusted Location allows files in the designated folder to bypass some security checks. Choosing your general Downloads folder extends that treatment to other documents saved there, including future downloads from unrelated sources.

For a recurring internal workbook, a controlled folder containing approved templates may serve a different purpose. Microsoft’s location-management guidance recommends limited folders and control over who can add or modify their contents. The person managing a shared distribution folder also needs to manage its write permissions.

If you previously designated an unnecessarily broad folder yourself, review File → Options → Trust Center → Trust Center Settings → Trusted Locations. Select its entry and remove it from the list. This removes the trust designation; it does not delete the folder. Have IT review entries controlled by organizational policy.

Supplier signatures offer another distribution approach. However, trusting a publisher covers all code signed with that certificate. It is a decision about the publisher’s identity and certificate, with a broader effect than inspecting one workbook.

Three reasons the workbook can still fail

You entered the figures in a browser. Open that workbook in installed Excel to run its VBA. Excel for the web lets you edit worksheet values and preserves existing macros, but cannot run, create, or edit those macros. For a template whose macro generates a report, you can finish entering the figures online and continue with report generation in the desktop app.

An ActiveX restriction remains. Another user question describes an Excel program blocked by both macros and ActiveX. The exact warnings matter: an unresponsive button alone does not prove it uses ActiveX.

ActiveX is disabled by default in Microsoft 365 and Office 2024. Changing its settings affects all files across several Office applications. Ask the supplier about a compatible workbook or an alternative without ActiveX before treating a broad settings change as the next step for one template.

The code was removed during saving. Saving an .xlsm workbook as .xlsx leaves the macros out of the new file. Retrieve the macro-enabled original and keep the required format when saving your work. Renaming the extension does not reconstruct the missing VBA.

Give the supplier a report they can act on

Include the filename and extension, opening location, Excel version, and exact remaining warning. State which file you unblocked. If the workbook contains client or financial data, ask whether a blank template and the warning alone are enough for the investigation.

What you observed	What to include	What to ask
The workbook’s Properties has no Unblock checkbox	Properties showing the filename, the opening path, and Excel’s warning	Ask IT whether this is the approved distribution copy and how it should be opened.
The same source-related warning remains after Unblock	The path of the file you changed, the path you reopened, and the remaining warning	Ask IT to check the share’s security-zone classification and applicable macro policy.
The source warning disappears but ActiveX remains blocked	The remaining message, Office version, and affected button	Ask the supplier for a compatible release or alternative workbook.

Suppose you have already found that a server copy has no Unblock checkbox while an approved local copy does. Include both paths and their respective warnings in the same request. This is a way to report observations made within your organization’s rules, not a requirement to move company files elsewhere for a test. Even if the local copy runs, that result does not establish that every file on the server should be trusted. Ask which distribution location should be used next time.

“I downloaded ExpenseTemplate.xlsm from your site to our approved local folder. I selected Unblock in its properties and reopened that copy. The source-related macro warning is gone, but an ActiveX warning remains and the lookup button does not respond. Is there a version for our current Office installation?”

Use that example only if it matches what happened. If Unblock was absent, say so; if the file was opened from a server, give that location. For repeated distribution, ask the supplier to specify the required Excel version, whether the workbook uses VBA or ActiveX, and the supported delivery method.