Best way to protect Excel VBA code? [closed]

by

You can create Automation Add In.

An Automation Add In provides several advantages

  • Execution Speed : An Automation Add In written in VB6 is compiled to
    native machine code which runs much faster than the interpreted VBA
    languange.

  • Security : Unlike an XLA add in, you never distribute the source code to the end users. If your code has proprietary information or
    intellectual property value, that remains safely protected on your
    own computer. It is never distributed to the user. Your code can
    never be compromised.

http://www.cpearson.com/excel/automationaddins.aspx

More Related Contents:

  1. How to color all the rows based on the cell values
  2. Using a UDF in Excel to update the worksheet
  3. Loading addins when Excel is instantiated programmatically
  4. Excel’s fullname property with OneDrive
  5. How to insert an embedded picture?
  6. Copy Excel range as Picture to Outlook
  7. Obtain attribute names from XML using VBA
  8. Paste Excel range in Outlook
  9. Return RGB values from Range.Interior.Color (or any other Color Property)
  10. Translate text using vba
  11. Run-time error ‘1004’ : Method ‘Range’ of object’_Global’ failed
  12. “Can’t find Project or Library” for standard VBA functions
  13. How do I issue an HTTP GET from Excel VBA for Mac
  14. Copy sheet and get resulting sheet object?
  15. Sending mail using Outlook where the Send method fails
  16. How do I apply a SumIf Formula in a VBA Sub? Getting Error 1004
  17. Using a variable for row in (row,column) for a range in VBA
  18. Export chart as image – with click of a button
  19. Error13 in Excel VBA in data file
  20. How to get the path of current worksheet in VBA?
  21. Excel VBA to match and line up rows
  22. Change font color for a part of text in cell
  23. Create a new object using the text name of the class
  24. Excel cell from which a Function is called [duplicate]
  25. How to extract text within a string of text
  26. VBA copy rows that meet criteria to another sheet
  27. VBA Dialog box to select range in different workbook
  28. How can I loop through a subset of worksheets?
  29. How to Send Email When Computer is Locked?
  30. VBA, Combine PDFs into one PDF file

Leave a Comment