Password Protect Worksheet Viewing

[ByTheLake]

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

 

[Tom Ogilvy]

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.