Hi,
I am using xlSheetVeryHidden to hide sheets with sensitive data fro
user. But if the user knows the name of the sheet, he can simply acces
the data by referencing to the hidden sheet, e.g

=hiddenSheet!A1

Does anybody know a way to prevent this

--
Message posted from http://www.ExcelForum.com

I guess you could encrypt what's on the vh sheet


-----Original Message-----
Hi,
I am using xlSheetVeryHidden to hide sheets with
sensitive data from
user. But if the user knows the name of the sheet, he
can simply access
the data by referencing to the hidden sheet, e.g

=hiddenSheet!A1

Does anybody know a way to prevent this?


---
Message posted from http://www.ExcelForum.com/

.

Sensitive data in an Excel file are simply not safe. Remove them from the
file or assume that a skillful person can get to them. (Most companies does
usually not have more than 2-3 skillfull persons though :-)

--
HTH. Best wishes Harald
Followup to newsgroup only please

"cjorgensen " skrev i melding
...
Hi,
I am using xlSheetVeryHidden to hide sheets with sensitive data from
user. But if the user knows the name of the sheet, he can simply access
the data by referencing to the hidden sheet, e.g

=hiddenSheet!A1

Does anybody know a way to prevent this?


---
Message posted from http://www.ExcelForum.com/