hide sheet? uncheck sheet tabs? or ???

  • Thread starter Thread starter NetComm888
  • Start date Start date
N

NetComm888

In my workbook, I have a tab, let's call it "secret". Although I could
protect the sheet from being edited, I really don't want the client
even see it. I could either hide the sheet or go to tools/window
options/uncheck the sheet tab. But either way, the client still could
see it, if they know excel well enough.
so is there anyway that I could set up a password that controls who
can view the sheet.
Thanks in advance
 
This is your best option, but it is breakable by anyone who knows what they
are doing. However, the average user will not know that the sheet is there
or how to access it.

Sub HideModeratelyWell()
With Sheets("YourSheetName")
.Protect Password:="ThisIsBreakable"
.Visible = xlVeryHidden
End With
End Sub

Robin Hammond
www.enhanceddatasystems.com
 
Back
Top