LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Linking worksheet event codes Mr. G. Excel Worksheet Functions 7 July 15th 05 06:15 PM
How do I 'catch' a 'delete cells' event Eric Excel Discussion (Misc queries) 2 March 9th 05 07:22 PM
Same event, multiple sheets? Robert Smith Excel Discussion (Misc queries) 1 December 24th 04 11:36 AM
Excel Automation SelectionChange event cpotts Excel Discussion (Misc queries) 1 December 20th 04 05:15 PM
Worksheet Row Change event crazybass2 Excel Discussion (Misc queries) 4 December 8th 04 05:29 PM


All times are GMT +1. The time now is 06:58 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"