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!

 

[JackDanIce]

Read through:
http://www.ozgrid.com/Excel/hiding-excel-worksheets.htm

There's a description of very hidden which should do as you require

 

[VoG]

Try like this

Sub HideSheet()
With Sheets("Sheet1")
    .Protect Password:="pw"
    .Visible = xlSheetVeryHidden
End With
End Sub

 

[FinancialAnalystKid]

Try like this

Sub HideSheet()
With Sheets("Sheet1")
    .Protect Password:="pw"
    .Visible = xlSheetVeryHidden
End With
End Sub

Hmm...

Which leads me to: Is there a way to set a password so if someone wants to unhide a tab they are asked for a password. They need permission to view it?

I worry that if someone knows VBA and knows there is a hidden sheet they will be able to use the above script to unhide worksheets!

 

[VoG]

Not telling

Sub UnHideSheet()
With Sheets("Sheet1")
    .Unprotect Password:="pw"
    .Visible = xlSheetVisible
End With
End Sub

 

[JackDanIce]

Oh VoG!!

 

[ChrisM]

Make sure you set the PW for the VB editor to "lock for viewing" as well, otherwise any user can open up VB, select your sheet, and change the visible setting to 'Visible'.

You realize that no password in Excel is truly secure? I would never put any truly confidential data in a public workbook.

 

[FinancialAnalystKid]

Not telling

LOL I figured it out but...

Which leads me to: Is there a way to set a password so if someone wants to unhide a tab they are asked for a password. They need permission to view it?

I worry that if someone knows VBA and knows there is a hidden sheet they will be able to use the above script to unhide worksheets!

 

[FinancialAnalystKid]

Make sure you set the PW for the VB editor to "lock for viewing" as well, otherwise any user can open up VB, select your sheet, and change the visible setting to 'Visible'.

You realize that no password in Excel is truly secure? I would never put any truly confidential data in a public workbook.

The script will be on my Personal computer right? I'm not saving it in the sheet it will only be with 'me' so-to-speak if I only save it in my personal.xlsb right?

Now, how do you lock for viewing anyway?

 

[ChrisM]

Open VB Editor, go to menu Tools/VBA Project Properties

Then select tab "Protection"

Check box and type a password. Save file, then close and reopen your spreadsheet, open the VB Editor again and note the difference.

Regardless of whether the macro code is in the workbook or your personal workbook, it all depends on where the physical data resides. If it is in your regular workbook then be careful about sending it out. Do some google searches on excel security and you will quickly see that you don't want to put your life in its hands.