Hello

I'm currently trying to get notified in VBA if user opens/closes any
grouping on any worksheet. But there is no event in Excel2003 I could
trap.
Does anybody have any idea how I could get notified in my VBA-code.

Thanks in advance
Dirk

I'm not sure what notified means, but I think the worksheet_calculate event
fires if you're grouping rows--but not columns.

But lots of stuff causes that event to fire.


Dirk Flakowski wrote:

Hello

I'm currently trying to get notified in VBA if user opens/closes any
grouping on any worksheet. But there is no event in Excel2003 I could
trap.
Does anybody have any idea how I could get notified in my VBA-code.

Thanks in advance
Dirk

--

Dave Peterson

Hello Dave,

thanks for your answer, but that event only fires if
"Application.Calculation" is set to Automatic and if that grouping
contains cells that have to be recalculated.
So this is no solution for me.

Does anybody else maybe have an additional idea?

Thanks in advance,
Dirk

On Mon, 28 Nov 2005 12:07:31 -0600, Dave Peterson
wrote:

I'm not sure what notified means, but I think the worksheet_calculate event
fires if you're grouping rows--but not columns.

But lots of stuff causes that event to fire.

--

Dave Peterson

Yep, you're right.

I don't have a work around that overcomes manual calculation, but with
calculation set to automatic, you could add an =subtotal() formula somewhere
that depended on that range of rows that are grouped.



Dirk Flakowski wrote:

Hello Dave,

thanks for your answer, but that event only fires if
"Application.Calculation" is set to Automatic and if that grouping
contains cells that have to be recalculated.
So this is no solution for me.

Does anybody else maybe have an additional idea?

Thanks in advance,
Dirk

On Mon, 28 Nov 2005 12:07:31 -0600, Dave Peterson
wrote:

I'm not sure what notified means, but I think the worksheet_calculate event
fires if you're grouping rows--but not columns.

But lots of stuff causes that event to fire.

--

Dave Peterson

--

Dave Peterson