Private Sub Worksheet_Activate()
'do your stuff
End Sub
'This is worksheet event code, which means that it needs to be
'placed in the appropriate worksheet code module, not a standard
'code module. To do this, right-click on the sheet tab, select
'the View Code option from the menu, and paste the code in.
--
HTH
RP
(remove nothere from the email address if mailing direct)
"moorso" wrote in
message ...
I have a macro I would like to run when a partiuclar sheet is selected
in a workbook but cant find where that is covered. I would also like
that same macro to run when the sheet is closed and another sheet is
opened. Is there such a command in Excel? TIA
--
moorso
------------------------------------------------------------------------
moorso's Profile:
http://www.excelforum.com/member.php...fo&userid=8966
View this thread: http://www.excelforum.com/showthread...hreadid=380501