Passwords associated with worksheets do not affect the ability of the user
to see the worksheet. The viewing of the worksheet is protected at workbook
level and there is only one password for that.

If you can't separate your sheets into workbooks, you would have to concoct
code the hides and unhides the sheets and administers a password system.
Thus you would not give out the single password for protecting the structure
of the workbook.

Any such system is of minimal security at best as code to break workbook and
sheet level passwords is posted at least weekly on this forum.

--
Regards,
Tom Ogilvy

"ByTheLake " wrote in message
...
I have an excel worksheet that has about 8 tabs/worksheets. Each
worksheet has cell protection to only allow writing to approved cells.
Outside of that, I want to password protect each worksheet so that each
sheet cannot be viewed without a password. Each worksheet represents a
different person and I want the ability to 'hide' the information
contained in the other worksheets, and only grant access to that
specific worksheet. I need a solution that will work from multiple PCs
and in either 97 or 2000. Any help would be appreciated.


---
Message posted from http://www.ExcelForum.com/