Search notes:

Excel Object Model: Worksheet.scrollArea

The worksheet property scrollArea defines the the area within which a user can scroll a worksheet or select cells.

The value of this property is a string representing the area in A1-reference style (see application.referenceStyle).

activeSheet.scrollArea = range( _
   cells( 21,  3), _
   cells(125, 80)  _
).address

In order to allow scrolling on the entire sheet, the value must be set to the empty string ("").

See also