Groups/Outline

[NextYearSox]

I have a worksheet that contains Groups of rows and columns that are used for outlining. I can turn these on/off in visual basic (i.e., ActiveSheet.Outline.ShowLevels RowLevels:=1), but is there a way within VB to determine if the outline is turned on or off) - i.e.:

if ActiveSheet.Outline.ShowLevels RowLevels:=1 then ....

obviously, this format won't work; is there a format that will?

 

[GlennUK]

Look at the ShowDetail property.