sheet protection

[eliking510]

Hey!!
I have 5 hidden sheets and the main sheet is visible....
how can i protect the other sheets so when somone will unhide the other sheets, wil not be able to see unless he will type a password


Thanks for the help !!!

 

[Trevor G]

You can change the sheet from hidden to veryhidden that way they dont get to even have the chance to unhide them.

Select the sheet tab and then use right mouse button and view code
Make sure the properties window is dispalyed (View Menu) and at the bottom change Visible from xlSheetVisible to xlSheetVeryHidden

 

[eliking510]

thank you , but im looking for something with password so it will be very secured

 

[Trevor G]

If you just have the sheets hidden you are still allowing the users to unhide which they still can see without a password.

Look to create a button on a sheet like sheet one and add this code which will ask for a passowrd if correct then the user will see it and it becomes the selected sheet otherwise a message is displayed, test this on a new owrkbook first if it worsk then add to your workbook, then adjust the code to unhide the other sheets.

Sub unhide1()
Dim strpassword As String
strpassword = "help"
If InputBox("Please enter the password", "Test") = strpassword Then
Sheets("Sheet2").Visible = True
Sheets("Sheet2").Select
Else
MsgBox "Sorry you entered the wrong password"
End If
End Sub