You can hide a sheet and password protect the workbook under
ToolsProtectionProtect Book.
Just be aware that Excel internal passwords are very easy to crack.
You have stated you don't want to protect the workbook so method 2 is another
option.
You could through
VB Editor make the sheet xlveryhidden then put password
protection on the VBA project. This password is quite a bit harder to crack.
Sub test()
Worksheets("Sheet1").Visible = xlVeryHidden
' Worksheets("Sheet1").Visible = True
End Sub
Gord Dibben MS Excel MVP
On Tue, 15 Aug 2006 10:27:55 -0400, carstowal
wrote:
to add to Phils question.
I want to be able to hide the sheet and protect it so that to unhide it
requires a password.
But I don't want to protect the entire workbook because others need to
add to it.
I haven't found a way to protect some content from others unless I hold
it in another workbook and link them. (and unfortunately that simple
excel feature is way to much for my boss to deal with!) ;)