Lock macro's from being edited
 

Hi. I have recorded a few macros and attached them to an object in Excel. I
need to leave one worksheet unlocked so that users can paste data in the
"Working" tab before clicking on the object to run the required macro.

I want to stop users from being able to access the macro though - via Tools,
Macro, Macros... - as someone has tried this without understanding the macro,
and it has been corrupted.

Any ideas? I'm using version 2000 if it makes any difference...

Lock macro's from being edited
 

Hi,

Try:-

Alt+F11

Tools|VBA Project Properties|Protection

Check 'Lock project for viewing' and apply a password.

Mike

"Tinkerbell.1178" wrote:

Hi. I have recorded a few macros and attached them to an object in Excel. I
need to leave one worksheet unlocked so that users can paste data in the
"Working" tab before clicking on the object to run the required macro.

I want to stop users from being able to access the macro though - via Tools,
Macro, Macros... - as someone has tried this without understanding the macro,
and it has been corrupted.

Any ideas? I'm using version 2000 if it makes any difference...