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.

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.