How do you reduce the size of a worksheet so that only 50 rows and/or a
select number of columns can be scrolled.

Elaine

Hiding the unused rows and columns then protecting the sheet is one method.

Setting the scrollarea using VBA is another method.

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:M50"
End Sub


Gord Dibben Excel MVP



On Tue, 8 Feb 2005 12:13:05 -0800, ElainePhd
wrote:

How do you reduce the size of a worksheet so that only 50 rows and/or a
select number of columns can be scrolled.