Not sure why you want to see a sheet tab but not the contents but......

You could format all cells to locked and hidden under
FormatCellsProtection.

Then Format all cells to white text.

Protect the sheet and not allow users to select locked or unlocked cells or
anything else.

Note: Excel internal security is very weak and passwords easily cracked.


Gord Dibben MS Excel MVP

On Mon, 27 Oct 2008 12:03:13 -0700, Joe
wrote:

Is there a way to prevent someone from viewing a worksheet. I know that I
can hide the worksheet and then password protect the workbook to prevent the
user from unhiding the sheet. I would prefer to still see the tabs but not
allow anyone to view that worksheet.