1

Besides adding a password under Project Properties > Protection (Which I think is actually quite easy to hack), how can I prevent users from viewing / copying my code?

Community
  • 1
  • 1
neelsg
  • 4,802
  • 5
  • 34
  • 58
  • 1
    [*.dll](http://msdn.microsoft.com/en-us/office/hh133430.aspx) –  Jun 21 '13 at 08:59
  • 1
    Possible duplicate http://stackoverflow.com/questions/16757119/best-way-to-protect-excel-vba-code/16758219#16758219 – Santosh Jun 21 '13 at 09:51

1 Answers1

2

May be this is the good possibility: http://msdn.microsoft.com/en-us/library/office/aa189867(v=office.10).aspx

To provide the highest level of security for your VBA code, use Microsoft Visual Basic version 6.0 to create a Component Object Model (COM) add-in. Because the VBA code in a COM add-in is compiled as a dynamic-link library (DLL), it can't be modified without access to the source code used to originally create it. Application-specific add-ins are not compiled; you must use the same protections as templates and documents.

Leo Chapiro
  • 13,678
  • 8
  • 61
  • 92