SheetActivate event
 

I have a workbook that contains a number of sheets. I want
to be able to pop up a message box when a user selects a
specific sheet. How do I do it?

Thanks

SheetActivate event
 

Hi Andy

Put this in the worksheets module

Private Sub Worksheet_Activate()
MsgBox ("Your Message here....")
End Sub



-----Original Message-----
I have a workbook that contains a number of sheets. I
want
to be able to pop up a message box when a user selects a
specific sheet. How do I do it?

Thanks
.

SheetActivate event
 

Many thanks for that - it worked a treat :)
-----Original Message-----
Hi Andy

Put this in the worksheets module

Private Sub Worksheet_Activate()
MsgBox ("Your Message here....")
End Sub



-----Original Message-----
I have a workbook that contains a number of sheets. I
want
to be able to pop up a message box when a user selects a
specific sheet. How do I do it?

Thanks
.

.