G
Guest
What is the most best way, with a macro, to Protect all worksheets in a
workbook using a popup asking for a password, and specify what functions a
users can use? And then to unlock it also, with a popup asking for the
password.
For example, I want to protect all the worksheets and have users be able to
"Select Unlocked Cells", "Select Locked Cells", and "Format Cells".
Also, to unprotect all the worksheets with a macro that pops up asking for
the password to unprotect all the sheets.
I hope that makes sense.
workbook using a popup asking for a password, and specify what functions a
users can use? And then to unlock it also, with a popup asking for the
password.
For example, I want to protect all the worksheets and have users be able to
"Select Unlocked Cells", "Select Locked Cells", and "Format Cells".
Also, to unprotect all the worksheets with a macro that pops up asking for
the password to unprotect all the sheets.
I hope that makes sense.