The selectionchange event is what I was looking for - Thanks!

"Tom Ogilvy" wrote in message
...
Use the selectionchange event in xl97 and later

See Chip Pearson's page on events
http://www.cpearson.com/excel/events.htm

Also, if you change the selection within the SelectionChange event, you
should disable events (reenable them at the end) within the event to
prevent
recursive calls.

--
Regards,
Tom Ogilvy