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 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
Try this:
File | Info | Properties | Advanced properties | clear the Author information. Save the workbook, close, and re-open.
File | Info | Properties | Advanced properties | clear the Author information. Save the workbook, close, and re-open.