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.