Aha, all is clear now. Off the top of my head the only thing I can think of is openning the spreadsheet in read only mode. I'm not sure, but I think this would prevent you from making changes in VBA as well as on the actual spreadsheet. I'm guessing that you want to have write permission to the spreadsheet, so this probably won't work for you. Sorry I can't help.


"Anita" wrote:

Okay,

My wording was bad on that one.

I do need to have access to the macros - as in I need to run them, but I
am not supposed to be allowed to change them without my changes getting
approval and and having the changes logged.

I have seen the password protect - but that makes it so I cannot view
the macro. Often times I'll step through my macros for the first few
files just to do control checks. I don't want to lose that capability.
I just need to be able to protect the macro so that I can't change it.

Is there any way to do this.

Thanks in advance for any help,
Anita


Anita

*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!