Just for my edification, does your solution depend on the VBA code being
protected from viewing (is your algorithm asymmetrical so that knowing
the encryption coding doesn't allow you to reverse the encryption)?

What encryption method are you using? Is it a standard, such as In
article ,
davidm wrote:

Manuel,

One dependable way to shield your confidential spreadsheet from
unauthorized users is to, in addition to "hiding" as suggested,
encrypt the sheet using VBA code. This strategy comes with the need to
have a parrarel "decrypting" code. The beauty of the encrypt/decrypt
artifice is that you can set your own "enrypt" key which, in the manner
of speaking, is well-nigh difficult for anyone to detect (even allowing
for the vast degree of password-breaking nous in computing). I have
developed one such twin-codes for encrypting and decrypting and have
been using them flawlessly with proven security. You may wish to
contact me by private mail for a copy.


david