Worksheet and workbook protection (via tools|Protection) is very weak and isn't
meant for security.

I wouldn't share any highly sensitive data in excel.

(If the user disables macros/events, then no macro solution will help.)

And if a user can find this newsgroup or google, they can find ways to unprotect
your workbook/worksheet.

Be very careful with what you share in excel.

Michael Link wrote:

Is it possible to protect a sheet in a workbook so that it isn't even
viewable unless you have the password? One of the sheets in my workbook
contaiins highly sensitive information that I don't want most folks to see,
but I want users to be continue to hide and unhide other elements in the
workbook to fit their needs.

Is there something I can write in VBA that will do the trick? In the perfect
world, what would happen is that, when a user clicked on the tab for the
Sensitive Sheet, a popup box would appear asking for a password. Is this even
possible?

Help! Any answers would be much appreciated.

Cheers!

--

Dave Peterson