Inserting code to call a routine when creating a worksheet

  • Thread starter Thread starter John
  • Start date Start date
J

John

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
 
One way:

Put this in the worksheet code module:

Private Sub Worksheet_Activate()
Call MyUpdateMacro
End Sub
 
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?
 
What code are you using to create the new sheet?

John said:
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?
Click to expand...
 
If OP simply copies the sheet, the code will go with it.


Gord Dibben MS Excel MVP
 
I thought yours was a valid question and my comment was really for the OP.

Should have posted a reply there instead.


Gord
 
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
 
Back
Top