Trapping expansion or collapse of outlines
 

Hi all,

Is there any way of determining when a user has expanded or collapsed an
outline level on a worksheet?

I have a number of worksheets which use outlines to display hierarchical
details. It's not a major problem, but users don't like the fact that
collapsing a given node doesn't collapse the levels below it (i.e. when they
reopen it, previously expanded levels are still open.)

If I can capture it happening, then I can probably work out some way of
rolling up the child nodes myself.

Cheers, Pete.

Trapping expansion or collapse of outlines
 

To the best of my knowledge, this doesn't fire any event.

If you had a cell containing subtotal that referenced all the rows, this
would trigger a calculate event in xl2003 I would think (earlier versions, I
don't think so). If you kept track of which rows were hidden then you might
be able to discern whether the calculate event was triggered by a change in
the number of hiddetn rows and then figure out which ones.

So bottom line is no built in support for it.

--
Regards,
Tom Ogilvy


"Pete McCosh" wrote:

Hi all,

Is there any way of determining when a user has expanded or collapsed an
outline level on a worksheet?

I have a number of worksheets which use outlines to display hierarchical
details. It's not a major problem, but users don't like the fact that
collapsing a given node doesn't collapse the levels below it (i.e. when they
reopen it, previously expanded levels are still open.)

If I can capture it happening, then I can probably work out some way of
rolling up the child nodes myself.

Cheers, Pete.