Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Protecting Macros -is it possible
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! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Protecting Macros -is it possible
"AlwaysAsking" wrote:
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Protecting Macros -is it possible
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! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Protecting Macros -is it possible
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Protecting a worksheet which has button controlled macros | Excel Discussion (Misc queries) | |||
Protecting a worksheet / workbook with macros | Excel Discussion (Misc queries) | |||
protecting macros for a protected sheet | Excel Discussion (Misc queries) | |||
Protecting My Macros | Excel Worksheet Functions | |||
protecting cells with macros | Excel Programming |