View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default Display MsgBox when selecting a sheet

Horatio,

Right click the sheet tab, view code and paste this in

Private Sub Worksheet_Activate()
msg = "You activated "
MsgBox msg & ActiveSheet.Name
End Sub

Mike

"Horatio J. Bilge, Jr." wrote:

Is there a way that I can have a message box display whenever a particular
sheet is selected?

Thanks,
~ Horatio