lock macro (make grey)

T

Tom

Hi,

Do you know how te lock a Macro, so you can't click Edit
or if there is a debug in the macro, you can't click
debug, only choose end ?

Thx
Tom
 
T

Trevor Shuttleworth

Tom

press Alt-F11 to load the VB Editor.

Select Tools | VBA Project Properties, select the Protection tab, lock the
project for viewing and enter a password.

Regards

Trevor
 
Top