VBA Code Protection

[LordageCol]

Hi to all,

I would like to know your opinions and experiences about this topic. As you know, is easy obtain the VBA password in any project. There are many tools for this purpose.

There are different options to protect the intellectual property:

-Protect the project with password
-Protect the code with obfuscation techniques (scramble)
-Build a Add-In (But the code must be protected anyway)
-Build a .dll file to use in Excel (But you will need to have knowledge of other language to develop)
-Build an Excel solution with Visual Studio and generate a workbook or add-in that depend of .Net framework
-Protect the VBA code with scramble tools that in general do not work as expected.

And what happen if you want to sell your applications ? How do this ..?

Can you share your experiences ..?

 

[NARAYANK991]

Hi ,

I don't have any experience , but you might find these links interesting :

http://www.excelforum.com/excel-pro...261-secure-license-and-sell-spreadsheets.html

http://j-walk.com/ss/excel/tips/tip100.htm

Narayan

 

[LordageCol]

Hi Narayan,

Thank you for your answer. AppSentinel could be a good idea to prevent copies, but not to protect the code. This means (I guess...) that is better to develop any solution with an external file that can be used from Excel (maybe a .dll file imported from references in VBE editor).

From my point of view, is big problem to work with vba directly if you want to sell your products or to protect your intellectual property.