LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,069
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sub Routine Call From a Macro D. Jones Excel Discussion (Misc queries) 1 November 8th 07 11:01 PM
How can I create a worksheet in a routine and set the code name at kataiwo Excel Programming 2 September 16th 06 04:12 PM
How to keep a Variable alive after a Call to Sub Routine Dennis Excel Discussion (Misc queries) 2 July 27th 05 10:57 PM
How to call a VBA routine in an add-in from a VB app? Camden Excel Programming 1 November 1st 04 05:17 PM
Call MS Word envelope printing routine? Richard[_28_] Excel Programming 0 April 27th 04 09:08 PM


All times are GMT +1. The time now is 05:38 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"