Worksheet tab protection

[Guest]

Hi, does anyone know if excel 2003 allows us to set a password for each
worksheet tab. What I mean by this is that each time a person clicks on the
worksheet tab they need to put in a password before being able to access that
worksheet.
Thanks.

 

[Mike H]

Hi, does anyone know if excel 2003 allows us to set a password for each
worksheet tab. What I mean by this is that each time a person clicks on the
worksheet tab they need to put in a password before being able to access that
worksheet.
Thanks.

If you mean to prevent all access, including viewing, then someone else
will have to chime in here. Otherwise, have you investigated the options
that you have under tools | options | Protect sheet?

 

[Don Guillett]

If just the data is to be protected, you could use a worksheet_activate
event asking for the password to unprotect the sheet.

If you want the sheet hidden unless the user is authorized then use a macro
that hides (xlveryhidden) the worksheets and asks for a password to make the
sheet visible.