As a developer, you may experience problems with Excel macros not opening on your local workstation, even after activating them and unblocking the file. Such issues frequently develop when working with shared resources such as sharepoint.com.
To resolve this issue on a Windows machine, consider taking the following steps. I found these steps helpful when I faced a similar problem with a shared Excel file containing a macro:
- Open Internet Options.
- In the Security tab, select Trusted Sites and then click on the button Sites.
- Finally, type the URL of the site or server that contains the Microsoft 365 files with the macros, and click Add.
After this update, you should be able to open the file and macro. Make sure you are logged in to Microsoft Excel locally with the email that was shared the file and macro.
My business tried this and it worked.