| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Starting a macro when switching to a worksheet?
Hi,
I would like to start a designated macro when switching to a certain worksheet. Is there anything similiar to the AutoOpen-Method of workbooks? Bye Markus |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Starting a macro when switching to a worksheet?
Worksheet_Activate() ??
knut "Markus Mueller" skrev i melding oups.com... Hi, I would like to start a designated macro when switching to a certain worksheet. Is there anything similiar to the AutoOpen-Method of workbooks? Bye Markus |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Starting a macro when switching to a worksheet?
Hi Markus,
Use the Worksheet_Activate event. For more information on event procedures, see David McRitchie's Events page at: http://www.mvps.org/dmcritchie/excel/event.htm For an in depth discussion of Event procedures see Chip Pearson's Events page at: http://www.cpearson.com/excel/events.htm --- Regards, Norman "Markus Mueller" wrote in message oups.com... Hi, I would like to start a designated macro when switching to a certain worksheet. Is there anything similiar to the AutoOpen-Method of workbooks? Bye Markus |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Starting a macro when switching to a worksheet?
Thanks a lot to both of you, that was exactly what I was looking for.
Bye Markus |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| switching the worksheet? | Excel Discussion (Misc queries) | |||
| Not switching to next worksheet | Setting up and Configuration of Excel | |||
| Switching to a tab in the worksheet | Excel Programming | |||
| selecting cell range in other worksheet without switching to worksheet | Excel Programming | |||
| Prevent Users from switching worksheet | Excel Programming | |||
Linear Mode
