Hi

I think you may try to secure the VBA project via password, so that other
can not view the code in your vba macro.
You may try to open the vba project IDE where the macro locates and then
right click on the vba project, select VBAProject properties.
Select Protection Tab and check Lock Project and set the password.

XL97: How to Create an Add-in File in Microsoft Excel 97
http://support.microsoft.com/kb/156942/en-us

Best regards,

Peter Huang
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.