Sleeper: Encrypting VBA Code - Third party tools?

[mrpaulwass]

Are there any aftermarket (third party) software tools to encrypt the VBA code?
Thanks for your help.

Paul

[Richie(UK)]

Hi Paul,

Welcome to the forum.

Who are your intended users for the code?
What is your objective?

If you just want to protect your code from modification by the average user (whatever one of those is) then there is a strong chance that the built-in project protection will be sufficient. This is not a 100% guaranteed secure route - the encryption is relatively weak and easily overcome if you know how. That said, most users don't even know that macros exist! ;)

For a more secure approach you may wish to look at com add-ins.

[mrpaulwass]

Thanks for the reply.

Yes, I'm looking to guard against more than the average user. I've never written COM code for excel, which is why I wondered if there was third party software that could be purchased to protect/encrypt the VBA code.

Thanks for the help.

Paul

[Bob Phillips]

Thanks for the reply.

Yes, I'm looking to guard against more than the average user. I've never written COM code for excel, which is why I wondered if there was third party software that could be purchased to protect/encrypt the VBA code.

Thanks for the help.

Paul

Paul,

Another way is to create a simple DLL in VB that does dsome of the critical work. You can link to the DLL in your code, but as compiled code, no-one will ever see it.

Either way, DLL or COM Add-in, you need VB.