Worksheet.ScrollArea Property (Excel)
Returns or sets the range where scrolling is allowed, as an A1-style range reference. Cells outside the scroll area cannot be selected. Read/write String.
Syntax
expression .ScrollArea
expression A variable that represents a Worksheet object.
Remarks
Set this property to the empty string ("") to enable cell selection for the entire sheet.
Example
This example sets the scroll area for worksheet one.
Worksheets(1).ScrollArea = "a1:f10"