Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Outline.ShowLevels
Hi TWIMC,
Is there a way that if I set the outline.showlevel to 2, that all levels below are collapsed, so that if a user clicks on the 3rd level, levels 4, 5 and 6 don't show. Or is there a way to find out how many row levels there are so that I can collapse each level and then set outline.showlevel to 2? e.g. for Z = worksheet.rowlevels.count to 1 Step -1 worksheet.outline.levels = Z Next Z worksheet.outline.levels = 2 TIA KM |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Grouping and outline | Excel Discussion (Misc queries) | |||
Outline Numbering | Excel Worksheet Functions | |||
outline | Excel Worksheet Functions | |||
Outline.ShowLevels | Excel Programming | |||
CONDITIONAL OUTLINE | Excel Programming |