Hiding a Worksheet w/a Password?

Hello Friends,

I have a shared workbook and have locked down the cells that shouldn't be changed by other users but I also have sensitive data that I don't want to have to put on a separate file. Is there a way to password protect (or some other means) so that if the user clicks the tab, it tells them "you're not allowed to view this tab" (or something to that effect)?

Many thanks in advance!

Rose

Hello Rose,

when you say "shared workbook", does that mean that several people access the workbook at the same time? If so, that will sooner or later lead to trouble. Shared workbooks are notoriously unreliable, and it's more a question of "when" rather than "if" they will become corrupt.

If you mean that the workbook is in a shared location, and only one user accesses it at a time, you could hide the worksheet with the sensitive data, or even use VBA to set it to VeryHidden. A savvy user may be able to find a workaround, though.

cheers,