Protect code/cells using Function/DLL??

[bobcat]

I have a pretty large excel sheet that I'd like to make as
secure as possible. Ideally, I would like to hide formulas
in cells in addition to protecting all the macro(vba) code.

While it is clear to me that the built in password-
protection (protect sheet/workbook, etc.) is not very
secure, I'm not sure what my options are.

While I have written a pretty sophisticated spreadsheet
that I'd like to secure (code and cells), I'm a newbie
when it comes to security, dlls, etc.

Can someone suggest a basic (remember I'm a newbie)
outline; how I would go about researching and implementing
a method to accomplish these tasks. Thanks for your
thoughts.

 

[Frank Kabel]

Hi
IMHO nearly all of Excel's build-in security measures are weak. Not
much you can do to create a decent level of protection.
the only secure way would be to put your code in a COM Add-in but this
may require rewriting your code.

Sorry to say but nearly all of your protection can be cracked in less
than some minutes 8using fee available tools). Excel is not build for
this kind of applications