I want to Auto lock My workbook after 1 year.

0

i make one worksheet with formulas for my clients. it have different formulas and its basically a datasheet. i want to that after specific period of time .  this workbook will be auto locked. all cells should be locked and cant be changed. 

Answer
Discuss

Discussion

Just make a macro that checks the date every time the workbook is opened and, if 1 year has passed from the date that you want to check, lock everything with a password. Then, password protect the vba module so the user can't see the password that you used to lock it.
don (rep: 1745) Oct 15, '19 at 10:09 am
Can you make one ? I have no idea about how to make macro
madserv Oct 15, '19 at 1:55 pm
Add to Discussion



Answer the Question

You must create an account to use the forum. Create an Account or Login