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

"NetComm888" wrote in message
om...
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