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
|