Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-03-2023, 02:18 AM
gmayor's Avatar
gmayor gmayor is offline macro to close document without saving but password protected Windows 10 macro to close document without saving but password protected 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
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
macro to close document without saving but password protected Close Document Without Saving Prompt Joe528 Word 3 10-08-2021 06:12 PM
macro to close document without saving but password protected Looking for ideas for a foolproof password-protected template/document Sarcas Word 2 09-11-2019 01:21 AM
VBA Macro to Open password protected Word Documents gennylk Word VBA 2 01-11-2018 11:03 PM
macro to close document without saving but password protected Macro to Unprotect password protected document pooklet Word 2 12-08-2014 01:32 AM
How to open a password-protected word document? navalava Word 1 07-01-2012 12:15 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:33 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft