View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
eDGAR eDGAR is offline
external usenet poster
 
Posts: 10
Default 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
.