uttamsaxena
Board Regular
- Joined
- Apr 22, 2003
- Messages
- 182
I have a workbook with 10 sheets, which all are protected by the password(Tools>Protection>protect) . Users only feed data and any change in sheet is to be done by me every month. For editing something in each sheet, I have to protect and unprotect all sheets one by one.How can this be done by a command button on sheet one, which should ask for the password and on correct password shall unprotect all the sheets. Similarly another button on sheet 1 should lock all the sheets on confirmation of a password.
However for unprotecting and protecting single sheet, the normal method (Tools>Protection>unprotect) should do.
However for unprotecting and protecting single sheet, the normal method (Tools>Protection>unprotect) should do.