Thread: macro to close document without saving but password protected
View Single Post
 
Old 02-03-2023, 02:18 AM
gmayor's Avatar
gmayor gmayor is offline Windows 10 Office 2019
Expert
  
Join Date: Aug 2014
Posts: 4,137
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default
From everything you have reported, I cannot see any good reason to have the document protected, if users can change it at will. The 'skeleton' document appears to be a template. Save it as a template and get users to create new documents from it. Then the macro and password would be superfluous.
As I mentioned earlier, you cannot make changes to a document and then retain those changes when you close it without saving it.
Clearing the data and saving it is problematical for a document that allows free editing. You would have to store the original content somewhere that the user has access to and replace the edited version with the stored original. None of this is necessary if you use a template.
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote