View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
MSweetG222 MSweetG222 is offline
external usenet poster
 
Posts: 158
Default Grouping & Outlining

I have a spreadsheet with 1000 rows of data and 4 layers of outlines. Some
of the collapsed items have only a few rows within the "+", while others have
100 rows within the "+".

When a users clicks one of the "+" items in the outline that has more than a
few rows, Excel shifts the users' "view" of the spreadsheet to the bottom of
the expanded item. I would like the users action of clicking a "+" to move
the user's view and cursor to the top of the expanded section.

Is there any VBA code to do this?

Thank you for your assistance.

Thx
MSweetG222