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...