marcros in excel has been blocked please help

Thank you for reaching out.

This behavior happens because of the macro security setting you selected.

When Excel is set to “Disable VBA macros except digitally signed macros”, it allows only signed and trusted macros. Any unsigned macro is blocked completely, and Excel will not show any “Enable Content” or “Unblock” option. That is why you are seeing the error without any option to enable it.

This setting is useful for security, especially in environments where files come from different sources. It helps prevent unsafe or unknown macros from running on the system.

To undo this setting, go to File → Options → Trust Center → Trust Center Settings → Macro Settings, and change it to “Disable VBA macros with notification.” After this, reopen the file and you will get the option to enable macros.

Please let us know if you require any further assistance, we’re happy to help. If you found this information useful, kindly mark this as "Accept Answer". So that others in the community facing similar issues can easily find the solution. Your contribution is highly appreciated.

this error was showing after Disable VBA macros except digitally signed macros

this was showing what i can do

Use the Trust Center and file “Unblock” options to allow your VBA macros to run, depending on what is being blocked.

1. Change macro settings in Excel (Trust Center)
   1. Open Excel.
   2. Select File > Options.
   3. Select Trust Center, then choose Trust Center Settings.
   4. Select Macro Settings.
   5. Choose one of these options (for VBA):
      • Disable VBA macros with notification – recommended so macros are blocked by default but can be enabled per file.
      • Or Disable VBA macros except digitally signed macros if using signed code.
   6. Select OK to save.
   Note: Macro settings in the Trust Center apply only to Excel, not to other Office apps. If the device is managed by work or school, an administrator might have locked these settings; in that case, contact the IT admin to change the policy.
2. Unblock a macro-enabled file from the internet/email If the workbook came from email, a download, or another machine, it may have “Mark of the Web,” which blocks macros even if Trust Center allows them.
   1. Close Excel.
   2. In File Explorer, right‑click the macro‑enabled file (for example, .xlsm).
   3. Select Properties.
   4. On the General tab, if there is a Security section with an Unblock checkbox, select Unblock.
   5. Select OK, then reopen the file in Excel.
   Alternatively, an admin can use the PowerShell Unblock-File cmdlet to remove the ZoneId (Mark of the Web) from the file so macros can run.
3. If “Unblock” is not visible
   • For files on a network share, the Unblock checkbox might not appear or might not work if the share is treated as Internet zone.
   • In that case, an admin should either:
     • Place the files in a location that is in the Local intranet zone, or
     • Designate the share or site as a Trusted site (noting this gives that site broader permissions beyond Office).
4. If Trust Center settings cannot be changed
   • If the macro settings and ActiveX settings are greyed out or locked, they are likely controlled by group policy.
   • Contact the organization’s IT administrator and request that:
     • VBA macros be allowed (for example, “Disable VBA macros with notification”), and
     • Any policy blocking internet macros for your trusted files be adjusted.

Once macro settings are relaxed appropriately and the file is unblocked, reopen the workbook; the macro security prompt should allow enabling content so the VBA project can run.

References:

• Change macro security settings in Excel
• Enable or disable macros in Microsoft 365 files
• Macros from the internet are blocked by default in Office
• This document was opened with macros disabled
• Excel is blocking untrusted XLL add-ins by default