In VBA, go to the Tools menu, choose VBAProject Properties, then the
Protection tab, check Lock Project For Viewing and enter a password.

Note that the security is very weak. I use VBAKey from Passware and it can
break a VBA password in seconds.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)



"SAM SEBAIHI" wrote in message
...
Is there anyway that you can lock macros and prevent from people seeing
them?

Thank you in advance