Worksheet Protection

  • Thread starter Thread starter Becky
  • Start date Start date
B

Becky

I have a user who wants a workbook with 40 tabs. He wants
to protect each tab from being viewed by any person unless
they have a password for the tab.
Example:
The workbook is for salary info with each tab representing
a supervisor and the contents are his employees. We want
all the info in one workbook but dont want the IS
supervisor to see the HR supervisors information.

Can you hide the data on a worksheet from view unless you
have the password for it?
 
You can, but the protection is not worth doing if you want the
information to be secure. It's relatively trivial to bypass any
protection in an XL workbook.

About the best he could do is to set the visibility of each sheet to
xlVeryHidden, then use a VBA routine to unhide the sheet if the
correct password is given, then hiding the sheet(s) again when the
file is closed. The passwords will have to be stored in the VBA
module, which can itself be password protected, but there are very
cheap commercial services out there that will remove it in a
heartbeat.

Worse, if your IS supervisor (or anyone else that has access) has
anything on the ball, it would be trivial for her or him to discover
the name of the sheet and unhide it directly.

A good rule of thumb is that if you don't want someone to view your
XL data, don't let them have access to the workbook.
 
Thank you, That is what I thought.
-----Original Message-----
You can, but the protection is not worth doing if you want the
information to be secure. It's relatively trivial to bypass any
protection in an XL workbook.

About the best he could do is to set the visibility of each sheet to
xlVeryHidden, then use a VBA routine to unhide the sheet if the
correct password is given, then hiding the sheet(s) again when the
file is closed. The passwords will have to be stored in the VBA
module, which can itself be password protected, but there are very
cheap commercial services out there that will remove it in a
heartbeat.

Worse, if your IS supervisor (or anyone else that has access) has
anything on the ball, it would be trivial for her or him to discover
the name of the sheet and unhide it directly.

A good rule of thumb is that if you don't want someone to view your
XL data, don't let them have access to the workbook.



.
Click to expand...
 
Back
Top