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

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