Protect single sheet

[TwiggyB1]

I understand it is not full proof, but what would be the code to protect a single worksheet in a workbook with a password. I don't want to hide it and then protect the workbook. I want both tabs visible and the second worksheet to be protected from seeing without the correct password.

Thank you

 

[rallcorn]

Sheet you want PW protected:
right click on the worksheet tab, choose "Protect Sheet" & protect w/ password

 

[TwiggyB1]

I know, but when I do this rolled are still able to viewthe contents of the sheet right? I thinking I need vba code to preventthem from seeing anything without a password.


Thanks

 

[rallcorn]

I don't think you can have it both ways:

I want both tabs visible

the second worksheet to be protected from seeing

 

[TwiggyB1]

Haha sorry! Yea that dosent make any sense! My bad.


The first tab can be visible to everyone and the second tab can only be visible to person with the password. So I only want one tab visible 100% of the time. If they click on the second it will ask them for a password.


Thanks

 

[rallcorn]

check out:
http://www.mrexcel.com/forum/showthread.php?t=515047&highlight=deactivate+worksheet