Hide And Password Protect A Sheet

[rockyw]

Can I hide and password protect a sheet? I have a form with a workbook as sheet 2. I would like to make this invisable to anyone without a password. Thanks

 

[VoG]

With code

With Sheet2
    .Protect Password:="anything"
    .Visible = xlSheetVeryHidden
End With

 

[Smitty]

You can set the sheet to xlVeryHidden in VBA. That way it's not available in the standard menu of hidden sheets. You could add some code to prompt for a password with an Input Box and if the correct password is input, then show the sheet, else not.

HTH,

EDIT: Sorry Peter, didn't see you there. My internet connection is slooooow today.

 

[rockyw]

The sheet I want to protect is sheet 2, I did rename the tab. Do I put this code on sheet 1, or sheet 2. Then when I want to unhide sheet 2, ot will ask for a password? Is that how it works? Thanks

With Sheet2
    .Protect Password:="anything"
    .Visible = xlSheetVeryHidden
End With