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.
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!
exeg Thank you so much for posting this. It was driving me crazy!
I understand you were able to solve this problem.
I added a local one-drive location and checked the "Subfolders of this location
I added also the online one-drive location and checked the "Subfolders of this location
Can you send a picture or something similar so I can understand better?
I thank you for the help- Make sure you also check the box at the bottom of Trusted Locations for "Allow Trusted Locations on my network"
- Try this:
File | Info | Properties | Advanced properties | clear the Author information. Save the workbook, close, and re-open.
- Thank you very much!! That worked for me
exeg
Thank you, exeg. I think that OneDrive online location made all the difference. I don't think I would have guessed that specific site location was the home of OneDrive.
Now that I can add my most important spreadsheets to OneDrive, which all have important macros, the software is actually useful to me!Thanks, exeg. That suggestion worked for me.
Others keep in mind that if you have assigned macros to objects, you may need to reassign them if you have moved the file.
