Run a macro each time sheet opened

[Jamie]

Hi There

I am looking to find a way to run a macro each time I open
a particular sheet in a workbook. Is there any way of
doing this?

Thanks in advance

Jamie

 

[Frank Kabel]

Hi
put the code in the worksheet_activate event procedure. See:
http://www.cpearson.com/excel/events.htm