right click sheet tabview codecopy thisSAVE

Private Sub Worksheet_Activate()
MsgBox "I popped up"
End Sub

--
Don Guillett
SalesAid Software

"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