how to compile or protect excel vba ?

[Luqman]

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

Best Regards,

Luqman

 

[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.

 

[Karl E. Peterson]

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

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.