Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
modifying a macro with a macro
I asked about this in a previous thread, and got some good references
to look at. What I'm hearing, without anyone saying so in so many words, is that I can't modify a macro from a macro. Is that correct? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
modifying a macro with a macro
Hi davegb
I always delete the whole macro and add a new one See http://www.cpearson.com/excel/vbe.htm -- Regards Ron de Bruin http://www.rondebruin.nl "davegb" wrote in message ps.com... I asked about this in a previous thread, and got some good references to look at. What I'm hearing, without anyone saying so in so many words, is that I can't modify a macro from a macro. Is that correct? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
modifying a macro with a macro
"davegb" wrote in message
What I'm hearing, without anyone saying so in so many words, is that I can't modify a macro from a macro. Is that correct? That is incorrect. You can use a macro to modify a macro, using VBA's Extensibility library. See www.cpearson.com/excel/vbe.htm -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com (email address is on the web site) "davegb" wrote in message ps.com... I asked about this in a previous thread, and got some good references to look at. What I'm hearing, without anyone saying so in so many words, is that I can't modify a macro from a macro. Is that correct? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
modifying a macro with a macro
One thing to consider is that xl2002 offered the user more security.
There's an option under: Tools|Macro|Security|Trusted Publishers If the user chooses to not "trust access to Visual Basic Project", then your code will have trouble making changes. This setting is a user-by-user setting. Your code can't change it. davegb wrote: I asked about this in a previous thread, and got some good references to look at. What I'm hearing, without anyone saying so in so many words, is that I can't modify a macro from a macro. Is that correct? -- Dave Peterson |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
modifying a macro with a macro
Tip: You can check this setting with code if you want
http://www.j-walk.com/ss/excel/tips/tip96.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Dave Peterson" wrote in message ... One thing to consider is that xl2002 offered the user more security. There's an option under: Tools|Macro|Security|Trusted Publishers If the user chooses to not "trust access to Visual Basic Project", then your code will have trouble making changes. This setting is a user-by-user setting. Your code can't change it. davegb wrote: I asked about this in a previous thread, and got some good references to look at. What I'm hearing, without anyone saying so in so many words, is that I can't modify a macro from a macro. Is that correct? -- Dave Peterson |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
modifying a macro with a macro
Ron de Bruin wrote: Tip: You can check this setting with code if you want http://www.j-walk.com/ss/excel/tips/tip96.htm -- Regards Ron de Bruin http://www.rondebruin.nl Thanks for all your replies. I must have misunderstood the previous posts on this topic. Will continue my research to see if this is feasible. As for access to the macros, they're all written by me, so I shouldn't have any problem there. "Dave Peterson" wrote in message ... One thing to consider is that xl2002 offered the user more security. There's an option under: Tools|Macro|Security|Trusted Publishers If the user chooses to not "trust access to Visual Basic Project", then your code will have trouble making changes. This setting is a user-by-user setting. Your code can't change it. davegb wrote: I asked about this in a previous thread, and got some good references to look at. What I'm hearing, without anyone saying so in so many words, is that I can't modify a macro from a macro. Is that correct? -- Dave Peterson |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
modifying a macro with a macro
But are you the only person who will run them?
davegb wrote: Ron de Bruin wrote: Tip: You can check this setting with code if you want http://www.j-walk.com/ss/excel/tips/tip96.htm -- Regards Ron de Bruin http://www.rondebruin.nl Thanks for all your replies. I must have misunderstood the previous posts on this topic. Will continue my research to see if this is feasible. As for access to the macros, they're all written by me, so I shouldn't have any problem there. "Dave Peterson" wrote in message ... One thing to consider is that xl2002 offered the user more security. There's an option under: Tools|Macro|Security|Trusted Publishers If the user chooses to not "trust access to Visual Basic Project", then your code will have trouble making changes. This setting is a user-by-user setting. Your code can't change it. davegb wrote: I asked about this in a previous thread, and got some good references to look at. What I'm hearing, without anyone saying so in so many words, is that I can't modify a macro from a macro. Is that correct? -- Dave Peterson -- Dave Peterson |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
modifying a macro with a macro
Dave Peterson wrote: But are you the only person who will run them? No, another person will be running them. Does that make a difference? She doesn't write code, so she won't be modifying them. It's a special app that only she uses for one specific purpose in one specific spreadsheet. davegb wrote: Ron de Bruin wrote: Tip: You can check this setting with code if you want http://www.j-walk.com/ss/excel/tips/tip96.htm -- Regards Ron de Bruin http://www.rondebruin.nl Thanks for all your replies. I must have misunderstood the previous posts on this topic. Will continue my research to see if this is feasible. As for access to the macros, they're all written by me, so I shouldn't have any problem there. "Dave Peterson" wrote in message ... One thing to consider is that xl2002 offered the user more security. There's an option under: Tools|Macro|Security|Trusted Publishers If the user chooses to not "trust access to Visual Basic Project", then your code will have trouble making changes. This setting is a user-by-user setting. Your code can't change it. davegb wrote: I asked about this in a previous thread, and got some good references to look at. What I'm hearing, without anyone saying so in so many words, is that I can't modify a macro from a macro. Is that correct? -- Dave Peterson -- Dave Peterson |
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
modifying a macro with a macro
You'll want to change that security level on her pc so that your code won't blow
up when it tries to access the project. davegb wrote: Dave Peterson wrote: But are you the only person who will run them? No, another person will be running them. Does that make a difference? She doesn't write code, so she won't be modifying them. It's a special app that only she uses for one specific purpose in one specific spreadsheet. davegb wrote: Ron de Bruin wrote: Tip: You can check this setting with code if you want http://www.j-walk.com/ss/excel/tips/tip96.htm -- Regards Ron de Bruin http://www.rondebruin.nl Thanks for all your replies. I must have misunderstood the previous posts on this topic. Will continue my research to see if this is feasible. As for access to the macros, they're all written by me, so I shouldn't have any problem there. "Dave Peterson" wrote in message ... One thing to consider is that xl2002 offered the user more security. There's an option under: Tools|Macro|Security|Trusted Publishers If the user chooses to not "trust access to Visual Basic Project", then your code will have trouble making changes. This setting is a user-by-user setting. Your code can't change it. davegb wrote: I asked about this in a previous thread, and got some good references to look at. What I'm hearing, without anyone saying so in so many words, is that I can't modify a macro from a macro. Is that correct? -- Dave Peterson -- Dave Peterson -- Dave Peterson |
#10
Posted to microsoft.public.excel.programming
|
|||
|
|||
modifying a macro with a macro
Dave Peterson wrote: You'll want to change that security level on her pc so that your code won't blow up when it tries to access the project. Does this apply to Office 2000? davegb wrote: Dave Peterson wrote: But are you the only person who will run them? No, another person will be running them. Does that make a difference? She doesn't write code, so she won't be modifying them. It's a special app that only she uses for one specific purpose in one specific spreadsheet. davegb wrote: Ron de Bruin wrote: Tip: You can check this setting with code if you want http://www.j-walk.com/ss/excel/tips/tip96.htm -- Regards Ron de Bruin http://www.rondebruin.nl Thanks for all your replies. I must have misunderstood the previous posts on this topic. Will continue my research to see if this is feasible. As for access to the macros, they're all written by me, so I shouldn't have any problem there. "Dave Peterson" wrote in message ... One thing to consider is that xl2002 offered the user more security. There's an option under: Tools|Macro|Security|Trusted Publishers If the user chooses to not "trust access to Visual Basic Project", then your code will have trouble making changes. This setting is a user-by-user setting. Your code can't change it. davegb wrote: I asked about this in a previous thread, and got some good references to look at. What I'm hearing, without anyone saying so in so many words, is that I can't modify a macro from a macro. Is that correct? -- Dave Peterson -- Dave Peterson -- Dave Peterson |
#11
Posted to microsoft.public.excel.programming
|
|||
|
|||
modifying a macro with a macro
I don't think it showed up until xl2002, but check just in case.
davegb wrote: Dave Peterson wrote: You'll want to change that security level on her pc so that your code won't blow up when it tries to access the project. Does this apply to Office 2000? davegb wrote: Dave Peterson wrote: But are you the only person who will run them? No, another person will be running them. Does that make a difference? She doesn't write code, so she won't be modifying them. It's a special app that only she uses for one specific purpose in one specific spreadsheet. davegb wrote: Ron de Bruin wrote: Tip: You can check this setting with code if you want http://www.j-walk.com/ss/excel/tips/tip96.htm -- Regards Ron de Bruin http://www.rondebruin.nl Thanks for all your replies. I must have misunderstood the previous posts on this topic. Will continue my research to see if this is feasible. As for access to the macros, they're all written by me, so I shouldn't have any problem there. "Dave Peterson" wrote in message ... One thing to consider is that xl2002 offered the user more security. There's an option under: Tools|Macro|Security|Trusted Publishers If the user chooses to not "trust access to Visual Basic Project", then your code will have trouble making changes. This setting is a user-by-user setting. Your code can't change it. davegb wrote: I asked about this in a previous thread, and got some good references to look at. What I'm hearing, without anyone saying so in so many words, is that I can't modify a macro from a macro. Is that correct? -- Dave Peterson -- Dave Peterson -- Dave Peterson -- Dave Peterson |
#12
Posted to microsoft.public.excel.programming
|
|||
|
|||
modifying a macro with a macro
I don't think it showed up until xl2002, but check just in case.
Correct -- Regards Ron de Bruin http://www.rondebruin.nl "Dave Peterson" wrote in message ... I don't think it showed up until xl2002, but check just in case. davegb wrote: Dave Peterson wrote: You'll want to change that security level on her pc so that your code won't blow up when it tries to access the project. Does this apply to Office 2000? davegb wrote: Dave Peterson wrote: But are you the only person who will run them? No, another person will be running them. Does that make a difference? She doesn't write code, so she won't be modifying them. It's a special app that only she uses for one specific purpose in one specific spreadsheet. davegb wrote: Ron de Bruin wrote: Tip: You can check this setting with code if you want http://www.j-walk.com/ss/excel/tips/tip96.htm -- Regards Ron de Bruin http://www.rondebruin.nl Thanks for all your replies. I must have misunderstood the previous posts on this topic. Will continue my research to see if this is feasible. As for access to the macros, they're all written by me, so I shouldn't have any problem there. "Dave Peterson" wrote in message ... One thing to consider is that xl2002 offered the user more security. There's an option under: Tools|Macro|Security|Trusted Publishers If the user chooses to not "trust access to Visual Basic Project", then your code will have trouble making changes. This setting is a user-by-user setting. Your code can't change it. davegb wrote: I asked about this in a previous thread, and got some good references to look at. What I'm hearing, without anyone saying so in so many words, is that I can't modify a macro from a macro. Is that correct? -- Dave Peterson -- Dave Peterson -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Modifying Macro | Excel Discussion (Misc queries) | |||
Need help modifying a macro | Excel Discussion (Misc queries) | |||
Help in modifying a filesearch macro! | Excel Programming | |||
Modifying an Old Excel Macro | Excel Programming | |||
Modifying Macro | Excel Worksheet Functions |