Thread: Show/Hide one of many outline/group levels
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Paul C Paul C is offline
external usenet poster
  
Posts: 269
Default Show/Hide one of many outline/group levels
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?


Reply With QuoteReply With Quote