Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Grouping and Outlining in Excel using sheet protection | Excel Discussion (Misc queries) | |||
Grouping/Outlining in Excel 2003 with Protection turned on | Excel Discussion (Misc queries) | |||
outlining / Grouping | Excel Discussion (Misc queries) | |||
Outlining with condition? | Excel Programming | |||
Protecting a worksheet but still allowing Outlining/Grouping? | Excel Programming |