Worksheet.ScrollArea (Excel)

Returns or sets the range where scrolling is allowed, as an A1-style range reference. Cells outside the scroll area cannot be selected.

Set this property to the empty string ("") to enable cell selection for the entire sheet.

Worksheets(1).ScrollArea = "a1:f10"