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.

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.