View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Horatio J. Bilge, Jr. Horatio J. Bilge, Jr. is offline
external usenet poster
 
Posts: 135
Default Display MsgBox when selecting a sheet

Thanks. It works great.
I was trying to use Workbook_SheetChange, but then I got the message for all
sheets, and I didn't know how to isolate the single sheet.

~ Horatio

"Mike H" wrote:

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