View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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