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")
Worksheets("yoursheet").Visible = True
Worksheets("yoursheet2").Visible = True
> 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