Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run worksheet level macro in a macro
I am trying to launch a worksheet level (on sheet
activated) event from another macro. I do not want to actually activate the sheet to get it to run though. Is there any way that I can do this? Let me know, and thank you in advance for the help! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run worksheet level macro in a macro
If you change the declaration of the Activate procedure from
Private to Public, you can call it from any macro. E.g., Sheet1.Worksheet_Activate -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Wandering Mage" wrote in message ... I am trying to launch a worksheet level (on sheet activated) event from another macro. I do not want to actually activate the sheet to get it to run though. Is there any way that I can do this? Let me know, and thank you in advance for the help! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run worksheet level macro in a macro
Chip,
That's the VBA name for the sheet as opposed to the worksheet name as displayed on the worksheet tab, right? AlexJ "Chip Pearson" wrote in message ... If you change the declaration of the Activate procedure from Private to Public, you can call it from any macro. E.g., Sheet1.Worksheet_Activate -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Wandering Mage" wrote in message ... I am trying to launch a worksheet level (on sheet activated) event from another macro. I do not want to actually activate the sheet to get it to run though. Is there any way that I can do this? Let me know, and thank you in advance for the help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Not able to KEEP Macro Security Level At Minimum | Excel Discussion (Misc queries) | |||
Detecting Macro Security Level | Excel Programming | |||
Detecting Macro Security Level | Excel Programming | |||
Using VBA to change macro security level | Excel Programming | |||
Macro to change security level | Excel Programming |