How do I protect a worksheet from being opened inside a workbook

[Guest]

I would like to know if there is a way to protect or lock a worksheet, inside
a workbook, so that other users cannot even open the worksheet. I am
familiar with how to password protect a worksheet so users cannot edit or
modify locked cells, however, I would like to keep other users from even
going into the other worksheets within the workbook. I have not yet found a
method for doing so.

Or is there a way to "hide" a worksheet within the workbook so that other
users cannot see it?

 

[Peo Sjoblom]

Format>sheet>hide

--
Regards,

Peo Sjoblom

(No private emails please)

 

[dominicb]

Good afternoon J Robinson

You could use the xlVeryHidden function, which is normally onl
accessible from the VBE (alt + F11, look in the properties window).
You could then lock the VBE for that particular workbook and passwor
protect it. The only way for MOST users to access this sheet would b
to know your password and use it from the VBE. However, nothing i
Excel is so secure that it cannot be circumvented without the passwor
by someone with a fair amount of knowledge.

The motto - if you want to protect a deep, dark secret, don't trust i
to Excel...

HTH

Dominic