Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Scrolling a split screen with VBA
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Scrolling a split screen with VBA
I can't say about the mouse wheel, but
Sub ABC() With ActiveWindow.Panes(1) .ScrollRow = 10 .ScrollColumn = 5 End With With ActiveWindow.Panes(2) .ScrollRow = 5 .ScrollColumn = 5 End With End Sub for VBA. I had one horizontal split line (upper and lower panels), so I didn't have but two panes. -- Regards, Tom Ogilvy "Otto Moehrbach" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Scrolling a split screen with VBA
Thanks Tom. Otto
"Tom Ogilvy" wrote in message ... I can't say about the mouse wheel, but Sub ABC() With ActiveWindow.Panes(1) .ScrollRow = 10 .ScrollColumn = 5 End With With ActiveWindow.Panes(2) .ScrollRow = 5 .ScrollColumn = 5 End With End Sub for VBA. I had one horizontal split line (upper and lower panels), so I didn't have but two panes. -- Regards, Tom Ogilvy "Otto Moehrbach" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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) |