Is it possible to put a limit on the columns/rows that can be scrolled
to when splitting the window into panes? This way the column/row labels
can be visible when you scroll through the main data area, but you
can't accidentally scroll into the labels from the main area, or the
data from the label area.

Thanks,
Rich

Rich,
It is only possible to set a .ScrollArea for the WS as a whole, not
individual panes and I assume freezing the panes is not suitable .
As there is no Scroll event, you cannot react to the scroll bars and reset
the panes display.

If you set ActiveWindow.DisplayHorizontalScrollBar/Vertical to false, the
user would have to select a cell to move. In the _SelectionChange you could
check the current visible range in the pane and decide if it is OK or not.

NickHK

wrote in message
ups.com...
Is it possible to put a limit on the columns/rows that can be scrolled
to when splitting the window into panes? This way the column/row labels
can be visible when you scroll through the main data area, but you
can't accidentally scroll into the labels from the main area, or the
data from the label area.

Thanks,
Rich