How to protect VBA code inside Excel?

How to protect VBA code inside Excel?

• garrone

  Forget about it! There is absolutely no reasonnable way to protect the code for real in any .xls 0r .xla file! They can all be cracked, even the one you are mentioning:
  
  Private Sub cmdDM_Click()
      Dim V, B, S, Z1, Z7, Z9, Z4, Z2
     
      'CW
         
      Dim ms As String
         
      ms = "Versuch doch mal an den Source zu kommen *fg*"
  
      MsgBox ms
  
  End Sub
  
  That's the code from that workbook. If  you want to impress the guy, send it to him. But i guess he knows himself.
  
  Sorry fot that!
  
  

• mordor_fr

  If you have access to the Developer version of Office or VB6, you can compile most of your code into an external .dll file. Then you can add a reference to the dll file in your VBA IDE. Call your functions and methods in the VBA IDE that are located in the dll without exposing the compllete code. Thats about the only reasonable solution.
  
  
• How to protect VBA code inside Excel?