Starting a macro when switching to a worksheet?

[Markus Mueller]

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

 

[DS NTE]

Worksheet_Activate() ??


knut

 

[Norman Jones]

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

 

[Markus Mueller]

Thanks a lot to both of you, that was exactly what I was looking for.

Bye Markus