ExcelBanter - View Single Post

JE McGimpsey

In article
,
wrote:

I am looking for a way to increase the security level - does anyone
know of a third party program that will secure it?

There is none. If someone has access to your file, they have access to
EVERYTHING in it, if they have the number and complexity of neurons to,
say, find these groups.

If you don't want someone to see your hidden data, don't include it in
the workbook.

One potential workaround would be to create a compiled COM add-in that
would store the data and perform any relevant calculations that are now
done in your hidden worksheets. It could then populate a workbook with
the results.

If your hidden sheets perform calculations on non-hidden sheets, the
add-in would need to detect the changes.