how to compile or protect excel vba ?

L

Luqman

How can I compile or protect excel vba code before giving excel file to
client ?

Best Regards,

Luqman
 
C

Charles Maxson

In the VBE, look under the menu Tools | VBA Project Properties, then on the
Protection tab you can lock the project and add a password. Hint: Use a long
password so it is less likely to be crackable.
 
K

Karl E. Peterson

Luqman said:
How can I compile or protect excel vba code before giving excel file
to client ?
Click to expand...

You can't. The "password protection" is offered by VBA is but a smokescreen. Cracks
abound.

If you really want to protect your source, the *only* option that's viable is to move
it into a VB5/6-authored ActiveX DLL.
 
Top