H

[Liz_I3]

Hi
I am working with an excel 2007 worksheet that contains many grouped outlines by row.

I have the below code to show or collapse All outline on a worksheet, but how can I have a button that will take the use to 1 specific outline and expand it, keeping all others collaped.


ActiveSheet.Outline.ShowLevels RowLevels:=1 or 2

Thanks
L

 

[shg]

Duplicated at http://www.mrexcel.com/forum/showthread.php?t=569953

 

[Liz_I3]

Yes, I know. I hit enter accidentally before I had a chance to type the title. Then could not delete the first post. Sorry for the inconvenience.

L