View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Dirk Flakowski
 
Posts: n/a
Default Event on opening/closing groupings in VBA

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