J
jacqui
I've used the Subtotal method to generate totals in my
datafile, however when I use the Selection.ClearOutLine
syntax, VBA removes the expansion/contraction lines with
the little minus/plus buttons but it doesn't remove the
ShowLevel buttons. When I do this manually in Excel ie
Data, Group and Outline then Clear Outline it does.
Can anyone provide the correct code to remove both the
lines and showlevel buttons.
Many thanks
Jacqui
datafile, however when I use the Selection.ClearOutLine
syntax, VBA removes the expansion/contraction lines with
the little minus/plus buttons but it doesn't remove the
ShowLevel buttons. When I do this manually in Excel ie
Data, Group and Outline then Clear Outline it does.
Can anyone provide the correct code to remove both the
lines and showlevel buttons.
Many thanks
Jacqui