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.
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