VBA Codes Protection

[Guest]

Hi

I like to protect my VBA application. I know Excel sheet password can be
broken. Even I can do it. But is it easy to break into VBA codes protected
for viewing?

If you know it I do not want to know how to do it because I am not going to
do it. But can you tell me how can I stop it? Will I have to merge some other
technology with Excel?

Thanks & Regards

M Varne

 

[Guest]

VB code protection is more robust than workbook/sheet protection but
inexpebsive commercial crackers will remove the protection very quickly.

The only safe method is to create you code as an add-in.

http://msdn2.microsoft.com/EN-US/library/aa166223(office.10).aspx

Mike

 

[Bob Phillips]

An add-in is no more secure than any other workbook.

If you really want to protect it, you need to write the important code in a
compiled language, such as VB, as a DLL say, and call the DLL in your
application.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)