how to unblock the excel macro

Question

how to unblock the excel macro? tried may times also cannot fix

Answer 1

To unblock Excel macros, you can follow these steps depending on your situation:

1. Unblock Individual Files:
   • Right-click on the Excel file, select Properties, and then check the Unblock checkbox on the General tab.
   • Alternatively, you can use the PowerShell cmdlet Unblock-File to remove the Mark of the Web from the file.
2. Files on a Network Share or Trusted Website:
   • If the file is located on a network share, you can unblock it using the same method as for individual files. If there is no Unblock checkbox, you can designate the location as a Trusted site or add it to the Local intranet zone.
3. Files on OneDrive or SharePoint:
   • Open the file using the Open in Desktop App option. If you download the file locally, make sure to unblock it as described above.
4. Macro-Enabled Template Files:
   • If the template file is stored on your device, remove the Mark of the Web and save it to a Trusted Location. If it's on a network location, use a digital signature and trust the publisher.
5. Macro-Enabled Add-In Files:
   • For PowerPoint or Excel add-in files, remove the Mark of the Web and save the add-in to a Trusted Location.

By following these steps, you should be able to unblock the macros in your Excel files successfully.

Answer 2

Hi, I'm John! I will help you with this.

You can first try checking the file’s Properties to remove the “Mark of the Web” security tag.

Right-click the Excel file, select Properties, and if you see an Unblock checkbox at the bottom, tick it and click Apply.

Have you already tried this step?