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

  • Thread starter Kevin McCartney
  • Start date
K

Kevin McCartney

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

macro to show / hide grouping, linked to label button 3
collapse an expand rows using VB 7
Trapping expansion or collapse of outlines 1
Need to Capture the initial value of a cell. 1
Grouping rows in Excel with the plus/minus icon in the first row 3
Group function with hidden rows 0
How to get expanded or collapsed state of task 3
Collapse all feature is not sticky 2

Top