| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Inserting code to call a routine when creating a worksheet
I have a macro that creates a new sheet from a template. Once the new sheet
is set up, I need to add a Call to another macro every time the sheet is selected by the user so that the sheet can be populated w/ current info. How & to where do I copy a short routine to do this call? What is the form of the Sub stmt that executes only when the user selects the worksheet tab and not when other activity takes place on the sheet? I appreciate your help, -John |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Inserting code to call a routine when creating a worksheet
One way:
Put this in the worksheet code module: Private Sub Worksheet_Activate() Call MyUpdateMacro End Sub In article , John wrote: I have a macro that creates a new sheet from a template. Once the new sheet is set up, I need to add a Call to another macro every time the sheet is selected by the user so that the sheet can be populated w/ current info. How & to where do I copy a short routine to do this call? What is the form of the Sub stmt that executes only when the user selects the worksheet tab and not when other activity takes place on the sheet? I appreciate your help, -John |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Inserting code to call a routine when creating a worksheet
This helps a lot. Now, what code do I use to copy these three lines into the
place where it needs to go after I create the worksheet so it gets executed when the worksheet is selected? "JE McGimpsey" wrote: One way: Put this in the worksheet code module: Private Sub Worksheet_Activate() Call MyUpdateMacro End Sub In article , John wrote: I have a macro that creates a new sheet from a template. Once the new sheet is set up, I need to add a Call to another macro every time the sheet is selected by the user so that the sheet can be populated w/ current info. How & to where do I copy a short routine to do this call? What is the form of the Sub stmt that executes only when the user selects the worksheet tab and not when other activity takes place on the sheet? I appreciate your help, -John |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Inserting code to call a routine when creating a worksheet
What code are you using to create the new sheet?
"John" wrote: This helps a lot. Now, what code do I use to copy these three lines into the place where it needs to go after I create the worksheet so it gets executed when the worksheet is selected? "JE McGimpsey" wrote: One way: Put this in the worksheet code module: Private Sub Worksheet_Activate() Call MyUpdateMacro End Sub In article , John wrote: I have a macro that creates a new sheet from a template. Once the new sheet is set up, I need to add a Call to another macro every time the sheet is selected by the user so that the sheet can be populated w/ current info. How & to where do I copy a short routine to do this call? What is the form of the Sub stmt that executes only when the user selects the worksheet tab and not when other activity takes place on the sheet? I appreciate your help, -John |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Inserting code to call a routine when creating a worksheet
If OP simply copies the sheet, the code will go with it.
Gord Dibben MS Excel MVP On Thu, 5 Feb 2009 10:51:36 -0800, JLGWhiz wrote: What code are you using to create the new sheet? "John" wrote: This helps a lot. Now, what code do I use to copy these three lines into the place where it needs to go after I create the worksheet so it gets executed when the worksheet is selected? "JE McGimpsey" wrote: One way: Put this in the worksheet code module: Private Sub Worksheet_Activate() Call MyUpdateMacro End Sub In article , John wrote: I have a macro that creates a new sheet from a template. Once the new sheet is set up, I need to add a Call to another macro every time the sheet is selected by the user so that the sheet can be populated w/ current info. How & to where do I copy a short routine to do this call? What is the form of the Sub stmt that executes only when the user selects the worksheet tab and not when other activity takes place on the sheet? I appreciate your help, -John |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Inserting code to call a routine when creating a worksheet
I know, my question was rhetorical. <g
"Gord Dibben" wrote: If OP simply copies the sheet, the code will go with it. Gord Dibben MS Excel MVP On Thu, 5 Feb 2009 10:51:36 -0800, JLGWhiz wrote: What code are you using to create the new sheet? "John" wrote: This helps a lot. Now, what code do I use to copy these three lines into the place where it needs to go after I create the worksheet so it gets executed when the worksheet is selected? "JE McGimpsey" wrote: One way: Put this in the worksheet code module: Private Sub Worksheet_Activate() Call MyUpdateMacro End Sub In article , John wrote: I have a macro that creates a new sheet from a template. Once the new sheet is set up, I need to add a Call to another macro every time the sheet is selected by the user so that the sheet can be populated w/ current info. How & to where do I copy a short routine to do this call? What is the form of the Sub stmt that executes only when the user selects the worksheet tab and not when other activity takes place on the sheet? I appreciate your help, -John |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Inserting code to call a routine when creating a worksheet
I thought yours was a valid question and my comment was really for the OP.
Should have posted a reply there instead. Gord On Thu, 5 Feb 2009 15:40:34 -0800, JLGWhiz wrote: I know, my question was rhetorical. <g "Gord Dibben" wrote: If OP simply copies the sheet, the code will go with it. Gord Dibben MS Excel MVP On Thu, 5 Feb 2009 10:51:36 -0800, JLGWhiz wrote: What code are you using to create the new sheet? "John" wrote: This helps a lot. Now, what code do I use to copy these three lines into the place where it needs to go after I create the worksheet so it gets executed when the worksheet is selected? "JE McGimpsey" wrote: One way: Put this in the worksheet code module: Private Sub Worksheet_Activate() Call MyUpdateMacro End Sub In article , John wrote: I have a macro that creates a new sheet from a template. Once the new sheet is set up, I need to add a Call to another macro every time the sheet is selected by the user so that the sheet can be populated w/ current info. How & to where do I copy a short routine to do this call? What is the form of the Sub stmt that executes only when the user selects the worksheet tab and not when other activity takes place on the sheet? I appreciate your help, -John |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Inserting code to call a routine when creating a worksheet
Gord, thank you for your response. It answered my question. It hadn't dawned
on me that the code would copy with the copy of the sheet- I thought I had to recreate it on the new worksheet. Frankly, coming from my frame of mind, I felt JLGWhiz's response was a little sarcastic and unhelpful. But it is always difficult to read someone's frame of mind via just a short post on the internet. Thx again, John "Gord Dibben" wrote: I thought yours was a valid question and my comment was really for the OP. Should have posted a reply there instead. Gord On Thu, 5 Feb 2009 15:40:34 -0800, JLGWhiz wrote: I know, my question was rhetorical. <g "Gord Dibben" wrote: If OP simply copies the sheet, the code will go with it. Gord Dibben MS Excel MVP On Thu, 5 Feb 2009 10:51:36 -0800, JLGWhiz wrote: What code are you using to create the new sheet? "John" wrote: This helps a lot. Now, what code do I use to copy these three lines into the place where it needs to go after I create the worksheet so it gets executed when the worksheet is selected? "JE McGimpsey" wrote: One way: Put this in the worksheet code module: Private Sub Worksheet_Activate() Call MyUpdateMacro End Sub In article , John wrote: I have a macro that creates a new sheet from a template. Once the new sheet is set up, I need to add a Call to another macro every time the sheet is selected by the user so that the sheet can be populated w/ current info. How & to where do I copy a short routine to do this call? What is the form of the Sub stmt that executes only when the user selects the worksheet tab and not when other activity takes place on the sheet? I appreciate your help, -John |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sub Routine Call From a Macro | Excel Discussion (Misc queries) | |||
| How can I create a worksheet in a routine and set the code name at | Excel Programming | |||
| How to keep a Variable alive after a Call to Sub Routine | Excel Discussion (Misc queries) | |||
| How to call a VBA routine in an add-in from a VB app? | Excel Programming | |||
| Call MS Word envelope printing routine? | Excel Programming | |||
Linear Mode
