Event on opening/closing groupings in VBA

D

Dirk Flakowski

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
 
D

Dave Peterson

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.
 
D

Dirk Flakowski

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
 
D

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.
 
Top