There have been quite a few questions this week on this
topic - try search on the NG

Basically, hide all the relevent sheets.
Add a userform - with a text box for the password with
the PasswordChar set to say asterisks. add another
textbox for the username. add an OK button & code it to
test the two entries - success should result in the
worksheets being made visible, while failure might result
in what? the workbook closing

Patrick Molloy
Microsoft Excel MVP
-----Original Message-----
I am looking for a way to hide a sheet for most of the
users. But some of the users should be able to see the
sheets. Therefore I am looking for a macro that unhides
the sheet with a password the selected users knows.

I am all out of ideas, and wondering if somebody knows a
way.

Thanks

Nicolay

.