Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Excel XP & Win XP
My screen is split with a horizontal split line so that I have an upper and lower panels or panes. In manual operation, my mouse scroll wheel scrolls the upper panel only, regardless of what I do. Question: How can I scroll (with the mouse scroll wheel only) either panel? With VBA, how can I address the panel of my choice so that I can scroll that panel (position a specific cell where I want it)? I know how to position the cell, but I don't know how to do it in the lower panel. The following code positions the cell in the upper panel regardless of what pane I put in the code, 1 or 3: ActiveWindow.Panes(3).Activate With ActiveWindow .ScrollRow = 5 .ScrollColumn = 5 End With Thanks for your time. Otto |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I lock a screen to prevent scrolling? | Excel Discussion (Misc queries) | |||
Scrolling one pane only in a vertically split worksheet | Excel Discussion (Misc queries) | |||
Slower scrolling when selecting rows more than a screen full. | Excel Discussion (Misc queries) | |||
How do I keep a text box on the screen when scrolling in excel? | Excel Discussion (Misc queries) | |||
How do I keep a text box on the screen when scrolling? | Excel Discussion (Misc queries) |