SheetActivate event

[Andy Palmer]

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

 

[Edgar]

Hi Andy

Put this in the worksheets module

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

 

[Andy Palmer]

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



.