xlSheetVeryhidden - still option to copy if you know the name of the sheet!

C

cjorgensen

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
 
H

Harald Staff

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 :)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hierarchy of Codename and error catching if no worksheet. 1
preventing referencing hidden cell 3
Trouble with copy of xlSheetVeryHidden 7
Search for values in a sheet and copy found records one after theother in another sheet 12
Copy adjacent Sheet and name from a list 42
Code to show/hide sheet to asterisk the password 1
Modify data on a hidden sheet? 5
Name the range AFTER copied to new sheet 6

Top