View Single Post
 
Old 06-30-2020, 03:42 PM
Guessed's Avatar
Guessed Guessed is offline Windows 10 Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,932
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

When you receive files containing macros from emails or a website, Windows now seems to set a protection value in the file so that macros will be disabled. It is possible that this is what has happened to you because you downloaded the file from OneDrive.

However it does sound like you can still run the macros but can't edit them which might mean my theory is wrong in this case. That behaviour sounds like the macros are in an addin rather than in the docm. Can you verify that the macros are contained in the docm that is open and not in a loaded addin?

If the macros are definitely in the open docm AND you are comfortable in working with xml I can explain how to edit the xml file where the protection is turned on.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote