Shawn,

In VBA, go to the Tools menu, choose VBA Project Properties, then
the Protection tab. There, check the "Lock Project For Viewing"
item and give it a password. Note, though, that there are a
variety of tools available on the net that will break this
password. There is no foolproof way to protect your VBA code.
Real code security is achieved only by writing your add in as a
COM/ActiveX DLL file.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com





"Shawn" wrote in message
...
Hi

What would be the best way to protect the code in an Excel
Add-In?

Thanks

Shawn