Outline, expand or collapse via VBA

K

Kevin McCartney

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
 
K

Kevin McCartney

Doooooooooooooooooh,

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

KM
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top