lock macro (make grey)
 

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

lock macro (make grey)
 

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


"Tom" wrote in message
...
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