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

's Computer Specifications

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

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Need to collapse an expanded Distribution List	David Dixon	Microsoft Outlook Discussion	2	3rd Sep 2009 05:08 PM
Automatically collapse a group by default	JD2	Microsoft Outlook Discussion	1	25th Jun 2009 11:57 AM
Assigning a key to expand or collapse a group	pavansut	Microsoft Outlook Discussion	0	19th Jun 2009 04:07 PM
Group of column can't be expanded or collapse after I set a protec	ToMMie	Microsoft Excel Misc	1	11th Sep 2008 07:06 PM
how to keep group collapse	Frank	Microsoft Outlook Calendar	0	1st Aug 2008 03:55 PM