View Single Post
 
Old 01-30-2023, 07:07 AM
elaineAda elaineAda is offline Windows XP Office 2010
Novice
 
Join Date: Mar 2019
Posts: 25
elaineAda is on a distinguished road
Default

Quote:
Originally Posted by elaineAda View Post
Hi BrianHoard
It didnt seem to work.
I have a turn around solution, it is to password protect the file, and user can only edit the file when user click on 'enable content.'
But the macro that i wrote cannot work perfectly.
Error message encountered when user save the file, and then close the file without saving the file. When user exit the file like that, the file was not save and became password unprotected.
When user try to access the file the next round, there is error message.
Is there anyway to go about this?
Basically it is to unprotect a password protected document, then re protect upon closing. Appreciate help on this.
Reply With Quote