Outline, expand or collapse via VBA
 

Hi T.w.i.m.c,

I've exported a pivot query to excel and I've formatted the rows to be
grouped in a certain way that groups rows with the same level number to the
next parent level number and once complete an collapse all of the outlines.
Located in another column I have a True / False value that I want to use as
an idicator to expand that rows outline. In that I only need to expand
certain row outlines not all of them.

I was hoping that I could record a macro to get the syntax when a user
clicks on the plus sign but no code is stored, I've looked at row.outline but
this set the level, so is there a row property that indicated the row is a
parent of a group and the you can set the "Expand" property to True or False
or something like that.

Any ideas would be very much appreciated.

T.I.A
KM

Outline, expand or collapse via VBA
 

Doooooooooooooooooh,

ShowDetail is the propery ..... helps to look a little futher :-)

KM

"Kevin McCartney" wrote:

Hi T.w.i.m.c,

I've exported a pivot query to excel and I've formatted the rows to be
grouped in a certain way that groups rows with the same level number to the
next parent level number and once complete an collapse all of the outlines.
Located in another column I have a True / False value that I want to use as
an idicator to expand that rows outline. In that I only need to expand
certain row outlines not all of them.

I was hoping that I could record a macro to get the syntax when a user
clicks on the plus sign but no code is stored, I've looked at row.outline but
this set the level, so is there a row property that indicated the row is a
parent of a group and the you can set the "Expand" property to True or False
or something like that.

Any ideas would be very much appreciated.

T.I.A
KM