Excel 2010 message when sheets are selected

[PWD]

Good afternoon, I have been asked to provide something that will pop-up when any particular sheet is selected - something that will explain the contents & purpose of the data on that sheet. (I did try searching this Forum for "On entry" but in its new & improved format it ignores the quotation marks & shows me everything with Entry or Entries - stupid 'enhancement' if you ask me!!) Anyway, gripe over; would anyone have any ideas of how I should approach this task? There are hyperlinks to some of these sheets & I wondered if there was anything that could be piggy-backed to them.

Many thanks,
D€$

 

[SkipVought]

hi,

There is a Workbook_SheetActivate event that could have code to display a message of some sort.

To explore this approch and get some advice, please post your VBA Code questions in forum707.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[PWD]

Thanx Skip; I'll get right on over there!!

Many thanks,
D€$