Hi
put the code in the worksheet_activate event

--
Regards
Frank Kabel
Frankfurt, Germany

"cdde" schrieb im Newsbeitrag
...

I need a macro to run everytime a peticular sheet/tab is choosen in
my
workbook......not all sheets....just 1 of them....

Lets just say the sheet is named "container quote".

Thank you in advance!

/Craig Hansen


--
cdde
---------------------------------------------------------------------
---
cdde's Profile:
http://www.excelforum.com/member.php...o&userid=15532
View this thread:
http://www.excelforum.com/showthread...hreadid=277137