Private Sub Workbook_Open()
Sheets("Sheet1").ScrollArea = ("A1:H10")
The above code will restrict the user to the range A1:H10. Unfortunately this setting isn't saved with the file so this code would need running every time the file is opened - hence the Workbook_Open routine. It needs copying into the ThisWorkbook module of the VBE.