Lock macro's from being edited

  • Thread starter Thread starter Guest
  • Start date Start date
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...
 
Hi,

Try:-

Alt+F11

Tools|VBA Project Properties|Protection

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

Mike
 
Back
Top