Stuart

You could use the Sheet_Activate() event, like so

Private Sub Worksheet_Activate()
MsgBox "Activated " & Me.Name
End Sub

To implement, check he

http://www.nickhodge.co.uk/vba/vbaim....htm#EventCode

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"swec74" wrote in message
...
I have been given a code to make a msg box pop up on opening the work book,
but is there any way to have that msg box pop up on a certain sheet insted
of
it poping up when the work book opens?

thanks for any help given.
regards
Stuart