HOW TO: capture the event when a row group is expanded or collapse
 

Hi TWIMC

I have rows 10 to 19 grouped and the grouping is collapsed. In cell (B20) I
have a function that reviews the rows(Index).ShowDetail so when collapsed it
returns the text "more...." thus when I expand the row group and show all the
rows, the return text in cell B20 will read "hide..." but the function only
re-calculates the cell when I activate it, so how do I refresh the calc for
the cell when the grouping is updated.

I don't want to recalc the sheet on the worksheet selectionchange event, so
is there away to see/capture the event when a grouping is expanded or
collapsed? Possibly, Outline?

TIA

KM