Subtotal Expend/Shrink (+/-) Group Buttons

[vladk]

Hi,

Is it possible to catch the very event of clicking at that buttons?

Thank you

vladk

 

[Rofeu]

Hi,

there is no event that captures clicking the expand/collapse group buttons.

Why would you need to capture this?

Cheers,

Roel

 

[vladk]

Rofeu,

I know that technically, there is no event for this. I am curious if any non straight methods can be found to intercept this.

vladk

 

[SkipVought]

Check out the Worksheet_Calculate event.

Skip,

_[red][/red]

 

[vladk]

SkipVought,

I did it ahead of time. It's not fired.

vladk

 

[SkipVought]

???

Skip,

_[red][/red]

 

[Rofeu]

Hi,

not sure how Skip thought of using the Worksheet_Calculate event to capture this, but if you have have Excel 2003 I think you can add a column and put numbers in there, then put something to the extend of =SUBTOTAL(109,A:A) somewhere in your sheet that's not grouped. It sums only the visible cells therefore it recalculates if you hide/unhide rows.

Cheers,

Roel

 

[vladk]

OK, Thank you guys!