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