protect worksheet before closing

P

PegL

SHould have said protect it if it ISN'T protected!
-----Original Message-----
Hello,

I have a worksheet that is protected leaving a few cells
unprotected for inputing data. If the user want to
modify the worksheet and leave it unprotected after the
changes is made, how can I set the worksheet to check the
protection and protect it automatically when the user
close the workbook?
 
Top