Note: Setting ScrollArea is good for that session only and only the
activesheet. Has to be reset next time workbook is opened.

Best to place the code into a WorkBook_Open Sub in ThisWorkbook module and
specify which worksheet.

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


Gord Dibben Excel MVP

On Wed, 23 Mar 2005 06:41:05 -0800, "abfabrob"
wrote:

Cheers!

" wrote:


-----Original Message-----
I have created a doc in excel, but I don't want users to
be able to scroll
down through the hundereds of empty cells below my two
pages. Or scroll right
across the hundreds of empty cells.

Can I restrict the size of a work shhet to prevent this
scrolling?

Rob
.

You can use code Worksheets(name of sheet).ScrollArea =
"a1:h60"

Try this code Worksheets(name of sheet).ScrollArea = ""