Worksheet tab protection
 

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.

On Sat, 15 Jan 2005 19:53:01 -0800, Xlim wrote:

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?
--
Mike H

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.

--
Don Guillett
SalesAid Software

"Xlim" wrote in message
...

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.