Protect and Hide a Worksheet tab?

[FinancialAnalystKid]

Is there a way to protect and hide a worksheet so other people cannot unhide and view it or know there is a tab hidden?

There is confidential information I need to hide without breaking up workbook into different copies.

Thanks!

 

[gmazza76]

Good Evening,

I have been looking at the VeryHidden vb that you have supplied on a previous enquiry.
I have used this but i cannot run VB that is looking at the hidden sheet.

Is there anyway round this, except for protecting the whole second sheet. If i protect the sheet via options can another person delete the sheet?

Many Thanks

 

[VoG]

Good Evening,

I have been looking at the VeryHidden vb that you have supplied on a previous enquiry.
I have used this but i cannot run VB that is looking at the hidden sheet.

Is there anyway round this, except for protecting the whole second sheet. If i protect the sheet via options can another person delete the sheet?

Many Thanks

You should be able to work with a hidden sheet in VBA - you just cannot select it.