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
|