Forum Discussion
Copied a Macro-Enabled Workbook into OneDrive, now macros cannot be run, edited, or deleted.
I assume you added your local Onedrive location.
now you should add the online Onedrive location name "https://d.docs.live.net/" make sure that you checked the "Subfolders of this location are also trusted"box.
Noted that you have to check the "Allow Trusted Locations on my network (not recommended)" box first.
The suggestion from exeg to add the online Onedrive location name "https://d.docs.live.net/" as a Trusted Location is spot on for people using Personal OneDrive. For people using a work or school account, your online OneDrive location will be different. To get the correct URL in that case, go to https://www.office.com/apps?auth=2 and open OneDrive. Copy the first part of the address, up through .sharepoint.com and add that to Trusted Locations (it will probably look something like https://yourcompany-my.sharepoint.com), and check the box for "Subfolders of this location are also trusted" so that macros will work in any folder in your OneDrive.
What is this process for a Mac? I have my One Drive shortcut into the Finder, but when I keep trying to upload a bunch of pptm files for PowerPoint that have macros enabled, every time I pull them up from within my OneDrive, the macros won't work!