You can set the scroll area,
In design mode, click the sheet properties and you can select the scroll area there.
10-7-2015 1-09-07 AM.jpg
Unfortunately, the scroll area will not save when you exit the workbook, so you will have to set the scroll area when you open the workbook, with VBA.
This goes into the Workbook Module.
![]()
Private Sub Workbook_Open() Dim sh As Worksheet Set sh = Sheets("Sheet1") sh.ScrollArea = Range("A1:AV24").Address End Sub
Bookmarks