View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Otto Moehrbach Otto Moehrbach is offline
external usenet poster
 
Posts: 1,090
Default 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