Lock macro's from being edited

T

Tinkerbell.1178

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

Mike H

Hi,

Try:-

Alt+F11

Tools|VBA Project Properties|Protection

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

Mike
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Password protecting multiple pages, and then some. 7
Documents from shared model are created with design mode on 1
MACRO's 3
macro to unlock and lock cells in password protected sheet 3
Keep macros from being ran under the tools option in the menu bar 3
A couple questions BEFORE using Office 365 0
Protect Cell from being edited 1
EXCEL 2007 Macro Security Being Ignored 5

Top