Ben

Through VBA

Since the scrollarea method does not stick between sessions you will have to
reset it each time.

You may wish to place the code into a WorkBook_Open Sub in ThisWorkbook module
and specify which worksheet if only one sheet required.

Private Sub WorkBook_Open()
Sheets("YourSheet").ScrollArea = "A1:T30"
End Sub

Or also in the Thisworkbook module to limit scrollarea on all sheets.

Private Sub Workbook_SheetActivate(ByVal Sh As Object)
With ActiveSheet
.ScrollArea = "A1:T30"
End With
End Sub


Gord Dibben MS Excel MVP

On Sun, 29 Oct 2006 08:59:01 -0800, Ben wrote:

Is there a way of preventing a user from scrolling left and right outside of
the screen area WITHOUT resorting to hiding the colums on either side.

Thank you

Gord Dibben MS Excel MVP