M
MSweetG222
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 user’s 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
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 user’s 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