Securing my vba code

[Bob G]

Am a relatively new developer and would appreciate
hearing about experiences with the password security
feature offered by vba.

I will be distributing Excel, PowerPoint and Word files
to users but I do not want them to be able to copy my vba
code.

Is the password protection offered for vba projects
adequate?

I don't expect my code to be as successful as MS Word but
I do want to prevent casual users from being able to copy
and reuse the code.

Thanks in advance!

 

[Stephen Bullen]

Hi Bob

There are VBA Project password crackers available on the internet, so in
theory it is possible for a determined hacker to get to your code. However,
I suspect the very, very few people would be bothered to do so.

If you're sufficiently concerned, implement the most sensitive bits as a VB
ActiveX DLL and call that from VBA.

--

Regards

Stephen Bullen
Microsoft MVP - Excel
www.BMSLtd.co.uk