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

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

Adjust the sheetname and range to suit.

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

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

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


Gord Dibben MS Excel MVP

On Sat, 19 Jul 2008 12:09:01 -0700, Scratchtfoot
wrote:

How does one restrict use in a small spreasdheet (15 columns x 30 rows)?
There's no need for other users to access the rest of the workspace, and I
would like to ensure that there is no confusion about the unused columns and
rows.