Forum Discussion
Solved
Copied a Macro-Enabled Workbook into OneDrive, now macros cannot be run, edited, or deleted.
I have a Macro-Enabled Workbook that I've been using for over a year with no issues in using the macros inside. Yesterday I copied this workbook into my OneDrive folder. Now, when I open the file...
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.
Having the exact same issue.
Our current workaround is to copy a file to your desktop, run the required macro there, then copy it back onto our shared Onedrive office folder.
But this is only a temporary solution, the best will be to allow macros to be run on Onedrive directly. Would love to see if the smart people can come up with a solution.
Just an added note, all files used to work perfectly before day before yesterday (6 September 2022). Problem only started then.
Peet_Luckhoff hi, we had the same issue, we could't get it work, even the very expensive external IT consultancy firm we hired (we paid over USD 100 per hour!!) couldn't get it work. So the solution we used at the very end is to switch everything to OneDrive Business accounts (as opposed to OneDrive Personal), it solves the problem at the expense of extra cost,
Thanks for the reply.
It is just weird that it has been working perfectly for a good 4 months now, and suddenly 2 days ago, it doesn't anymore.
When I say works perfectly, the different users could open the files on a shared onedrive folder, and run the macros in the files without issues.
Some added info, the macros are still enabled when I open the files on my pc, and only on my pc. I am the one who set up the Shared Onedrive Folder in the first place. However, it doesn't work on the other users pc's anymore. They have "Can Edit" Access to the folder.
Peet_Luckhoff the cause is because of Microsoft's security upgrade related to macro. please see below for the official documentation (https://docs.microsoft.com/en-us/deployoffice/security/internet-macros-blocked)
if that official documenttation cannot solve your issue, there is a community discussion on this, some found it helpful, please google "Microsoft has blocked Macros from running because the source is untrusted", the very first search result should be that one.
and again if you still cannot fix it, and i will assume you use OneDrive - Personal (not business) account, then what worked for us at the very end is bite the bullet and upgrade to business acount
