I have Created an Excel sheet. That has a lot of Macros Running.
I want to share the File on OneDrive with my Colleagues. so All of us can work on same file.
Now, Once they open the file from their OneDrive shared Folder in their Computer. It Blocks the Macros as Security Risk. I want these Macros to work on all users who have access to the file in OneDrive.
I have Tried adding the Trusted Locations from Macros Security. But it isn’t accepting the URL as Secure/Valid according to my MS Office Security Settings. I am not able to find any solution for the problem.
Wasif is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Can you share a screenshot of the message they get? I have not found issues there in the past. The only caveat is that I have needed to “enable content” or add developer features via options.