PDA

View Full Version : Ultimate VBA protection



theta
08-30-2012, 05:04 AM
What methods are available for scrambling VBA code?

AirCooledNut
08-30-2012, 09:19 AM
I just came across this
http://www.cpearson.com/Excel/CreatingCOMAddIn.aspx
That would be the best way to keep your code secure. Other methods involving Excel (like Lock the Project) are not secure.

theta
08-30-2012, 09:49 AM
Thanks :) Looks like I have alot of learning to do. VBA is coming along nice so time to learn C++ XLL, COM and Byte/hex level file interaction.

I will have to move to the COM approach, just found a 32 page doc showing how to circumvent every security method in excel/office. All except the 2007/2010 file open password (as this encrypts the file) - but what use is that to a product you hope to distribute. Once it's open, can just saveas without the password. And brute force will get you there.