How can you lock macros
 

Is there anyway that you can lock macros and prevent from people seeing them?

Thank you in advance

How can you lock macros
 

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

How can you lock macros
 

WOW! Thank you so much Chip

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