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