How do I enable a macro in Excel when uploading the excel file to sharepopint

Question

I'm uploading an Excel spreadsheet that contains a Macros from my PC to a SharePoint site. The upload works fine but the marco is disabled when I try to open the file from from SharePoint (opening in desktop app not browser).

Get the message below. Help please!

Answer 1

Hi,

The macros may be disabled by default due to security settings. This is to protect users from potentially harmful code.

To enable macros in the uploaded spreadsheet, you can follow these steps:

1. In the Security Warning dialog box, you are seeing a message stating that "Microsoft has blocked macros from running because the source of this file is untrusted." Click on the "Options..." button next to the message.
2. In the Trust Center dialog box, select the "Enable all macros (not recommended; potentially dangerous code can run)" option.
3. Click on the "OK" button to save the changes and close the dialog box.
4. You should now see a yellow bar at the top of the worksheet indicating that macros are enabled. You can now use and run the macros in the Excel file.

Best Regards.

Answer 2

Hi @Andrew Creathorn,

I suggest you follow this article and try the method to enable macro by deault:

https://learn.microsoft.com/en-us/deployoffice/security/internet-macros-blocked

Hope the information is helpful.

---

If the response is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.