VBA Security

[Guest]

I know there are some programs in the market that can be used to by pass or
"RECALL' the password for the excel VBA codes. How should we write it even
the password is correct, it will still delete or crash the whole excel to
prevent ppl reading the VBA codes.

Regards

 

[JE McGimpsey]

Can't do it within XL. A compiled COM add-in is much more secure.

 

[Guest]

Where can I find the compiled add-in?

Can't do it within XL. A compiled COM add-in is much more secure.

 

[DM Unseen]

COM addins can be written with VS or VS.NET or the Developer Editions
of MS Office. The VS/NET have more options as I recall.

Programming Office COM addins is however not as easy as coding XL
addins. Be prepared ot learn a lot!

Another option is to buy a code obfuscator(FMS Inc has one). This will
practically prevent code theft, but eventually not hacking of security
features(e.g. registration codes).

DM Unseen