Make my macro security
 

Hello,

After creating some macros, I want to let other friends
use it but dont want to let them see my macros.

Can I set password or other methods to make it secret?

Thanks for your kind help.

Make my macro security
 

in the VBE, with your workbook as the active project, go to
Tools=VBAProject Name Properties and in the second tab (protection), you
can set a password and check the box to not make your code visible (lock
project for viewing).

--
Regards,
Tom Ogilvy



"wooo" wrote in message
...
Hello,

After creating some macros, I want to let other friends
use it but dont want to let them see my macros.

Can I set password or other methods to make it secret?

Thanks for your kind help.