Darren,
Open the ThisWorkbook module and enter you code in the:
Private Sub Workbook_Open()

End Sub

NickHK

"DarrenG" wrote in
message ...

How do you get a macro to run whenever a worksheet is opened?


--
DarrenG
------------------------------------------------------------------------
DarrenG's Profile:
http://www.excelforum.com/member.php...o&userid=36529
View this thread: http://www.excelforum.com/showthread...hreadid=565060