thank you both. i will give these a try.
--
, Brian


"stumac" wrote:

You could have the worksheet hidden and the workbook protected this will mean
that users cant unhide the sheets without the password.

If you have macros enabled then you could also have a command button on one
of the active sheets to enable the users who are allowed to see the hidden
sheets to do so quickly, create a command button and use code something like

Private Sub CommandButton1_Click()

Dim passw As String
passw = InputBox("Enter Password to unhide sheets")
ActiveWorkbook.Unprotect (passw)
Worksheets("yoursheet").Visible = True
Worksheets("yoursheet2").Visible = True

End Sub

Hth

Stu

"Brian" wrote:

hello all,
i was wondering if there is a way to password protect a worksheet. i have
many workbooks with multiple worksheets that people have access to. there are
sheets that people do not need to see. i know i can hide these sheets, but i
would rather have a password to open them so that if there are people who
need to open them they can by entering a password.
thank you for your time and have a great day!
--
Thank You in advance, Brian