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.
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
I contacted Microsoft support on this and they could not resolve it. They did have me create feedback in the the MS Feedback Hub. https://aka.ms/AAi4hrx . Please upvote for my feedback to give it higher priority. I am using Windows 11, OneDrive Personal. Strangely, one workbook in the shared folder does still work with macros.
- hi paul, good to hear your active involvement in solving the issue, and sad to hear you have the same issue as many of us. Yes we tried microsoft support without any success too. Sadly MS won't do anything in its Feedback hub, its just there to give ppl false hope.
so if you need the issue to get fixed asap, the quickest and only known solution to mankind (but not yet known to microsoft support, lol) is to upgrade your account to business