Macro/XLA's - Strong security for Macros/XLA's

[lionelnz]

Hi there.

I want some advice on how to VERY securely password protect Macro's and XLA's.

The normal VBA protection & XLS protection is very weak and I know several ways around the normal protection options.

However addins that I have purchased or come with manuals are VERY securely protected and as my knowledge is extremely limited in this area I would like to know howto do this or where do I find info on this.

I have searched & googled but just throws up so many mismatches.

Thanks.

[Siddharth Rout]

Hi lionelnz

No they are not securely password protected. At least I haven't seen one of them. If you ask me, I would say that VBA protection unfortunately (be it 2003 or 2007) can be easily hacked...

[anhn]

The security implemented by password protecting a VBA Project is extremely weak. Password breakers are widely available. ... You should think of the password protection as a means to prevent an innocent user from mistakenly breaking something in the code. The security is not strong enough to protect proprietary code or code with intellectual property value. If you need that level of protection, you should be using a COM Add-In, not an XLA Add-In.

COM Add-In can be created using Visual Basic 6 (not VBA).