Message Box on Worksheet selection

  • Thread starter Thread starter Jennifer
  • Start date Start date
J

Jennifer

I am trying to figure out how to have the message box
appear upon selection or activation of a worksheet within
a workbook. When the user selects the worksheet, have the
message appear. I know I can use the auto-open macro and
include upon opening or use a button for selection of the
worksheet and hide the worksheet, but I would like to just
have the message when the worksheet is selected by normal
means.
Thanks!
 
Have a look at worksheet ACTIVATE to be found by right click on sheet
tab>view code or for all worksheets in the ThisWorkbook module.
 
Back
Top