Make my macro security

W

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

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