View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Josh O. Josh O. is offline
external usenet poster
 
Posts: 77
Default Multiple Worksheets - Protection

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.