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 |
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 |