Show/Hide one of many outline/group levels

P

Paul C

I have a Excel 2003 worksheet with 4 seperate outline/groups.

I start with all outlines collapsed.

I can use this code to expand/show them all

ActiveSheet.Outline.ShowLevels RowLevels:=2

Is there a method in VBA to expand or hide only one of the 4 groups?
 

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

Similar Threads

Data Extract from Multiple Worksheets Macro 4
outline question 1
Need some PWA help 0
Show not working after slide with hyperlink. PPT2011 for Mac 0
Grouping a range of sheets 10
HOW TO: capture the event when a row group is expanded or collapse 0
XL2002 - Group / Outline / ShowDetail... 1
Grouping & Outlining 0

Top