Password protect worksheets from being viewed within a workbook

[Guest]

I have a workbook which contains 4 worksheets. Each worksheet is relevant to
a certain individual and should not be viewed by anyone else. Is there a way
I can hide worksheets from being viewed within a workbook unless you have a
password to open? Or maybe there is another way to hide/protect these
worksheets.

 

[agarwaldvk]

Dear C Briggs

From the front end functionality, locking/hiding works only after th
workbook/worksheets are protected with or without a password
protecting without password doesn't carry much meaning anyhow! Furthe
Excel has never been promoted as a secure information platform.

For what you are looking for, what you can do is not have a password t
open the workbook and let the workbook open with a interface sheet a
the active sheet. Then using VBA you can write SheetActivate/Deactivat
procedures with an auto_open and auto_close sub procedures to ask for
password to change the active worksheet. These can be stored with i
the VBA code. But again keep in mind Excel is not supposed to be ver
strong on SECURITY.

The poorer front end option would be to protect individual worksheet
with individual passwords and not protect the workbook. Have all fon
colour the same as the background colour so that nothing is visible t
the user at first glance. The user can then use the password for th
specified worksheet and then change the font colour to a colou
different from the background to make the text visible against th
background.


Hope these help!


Best regards



Deepak Agarwa