Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 02-01-2023, 06:45 PM
elaineAda elaineAda is offline macro to close document without saving but password protected Windows XP macro to close document without saving but password protected Office 2010
Novice
macro to close document without saving but password protected
 
Join Date: Mar 2019
Posts: 25
elaineAda is on a distinguished road
Default macro to close document without saving but password protected

Hi Hi


I have problem writing a code to close a document but with password protected without saving if user does not want to save.

This code is not able to password protect if user decides not to save the file and exit word.

Code:
Private Sub Document_Close()

With ActiveDocument
    If .ProtectionType = wdNoProtection Then
         .Protect wdAllowOnlyReading, NoReset:=True
    Else
        .Unprotect
    End If
End With
Reply With Quote
 



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 07:57 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