lock macro (make grey)

[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

 

[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