Right-click on the sheet tab and "View Code"
Paste these lines in that module.
Private Sub Worksheet_Activate()
''your pop-up message code goes here
End Sub
Delete the code from the module it presently resides in.
Gord Dibben Excel MVP
On Sun, 2 Jan 2005 02:01:01 -0800, swec74
wrote:
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
|