Absolutely - no matter what - do not put that kind of information into
the distributed worksheet.

You, or your employer, will live to regret it.

I did that once, I worked for a big 5 consulting firm - I didn't know
about AddIns. My Workbook application priced health care plans. A
client broke into the Worksheet and started a competing business. My
customer got fired and I got laid off.

Learn how to use AddIns. They aren't that complicated and that's why
Excel created AddIns - precisely for this sort of thing.

Put those hidden sheets into the AddIn.

Look up AddIn an any of Walkenbach's texts. Two or three pages.


My client doesn't want every user to know of all the different deal options
that preferred clients of theirs sometimes get, hence the hiding of sheets,
etc. Also, some stuff will only confuse them - things like that, not the
compromise of data, per se, so I'm not sure the plug-in approach would help,
which is good because I have no idea what that is!!