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