You can't. You must assume that anything in your workbook is available
to anyone who has access to it.

You could use this command in the Visual Basic Editor's Immediate Window:

Sheets("Sheet1").Visible = xlVeryHidden

to make the sheet invisible in the menu, but this is rather trivial to
bypass.

There is no internal protection in XL that provides any security against
someone with the skill to find these newsgroups. See

http://www.mcgimpsey.com/excel/removepwords.html

and

http://www.mcgimpsey.com/excel/fileandvbapwords.html

for details.


In article om,
wrote:

How do I absolutely protect this sheet from viewing unless I enter a
password.