Protecting Macros -is it possible

[AlwaysAsking]

I was hoping that somebody would be able to help me with this.

I am suppose to protect my macros so that I cannot edit them without
getting approval. I've looked for this feature in the help - but I
cannot find anything.

The macros would have to be password protected without my having access
to the macro.

Thanks in advance for any help that you can provide.

Anita

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

 

[Guest]

I was hoping that somebody would be able to help me with this.

I am suppose to protect my macros so that I cannot edit them without
getting approval. I've looked for this feature in the help - but I
cannot find anything.

The macros would have to be password protected without my having access
to the macro.

I'm not sure exactly what you mean by the last sentence. It seems contradictary to me to password protect something you don't have access to. However, in VBA, under Tools -> VBA Project Properties you can set password protection. This will prevent someone from openning VBA to look at the macros for that project without inputting the password. Hope this helps.
Marcotte

 

[Anita]

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!

 

[Guest]

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.