| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Group of column can't be expanded or collapse after I set a protec | Excel Discussion (Misc queries) | |||
| Icon for inserted file object doesn't collapse away when closeoutline group | Excel Discussion (Misc queries) | |||
| Stop Capture Event | Excel Programming | |||
| Any way to capture an Autofilter event? | Excel Programming | |||
| Capture scrolling event | Excel Programming | |||
Hybrid Mode
