Make my macro security

[wooo]

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.

 

[Tom Ogilvy]

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