P
PegL
You can use the Workbook_BeforeClose event procedure in
VBA. You can check whether the worksheet is protected and
protect it if it is.
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?
VBA. You can check whether the worksheet is protected and
protect it if it is.
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?