Just put the following in 'ThisWorkbook':

Private Sub Workbook_Open()
Worksheets("Sheet1").ScrollArea = "A1:G50"
End Sub

--
Dan


On Apr 14, 11:39*am, exalan wrote:
How can I limit scrollarea say, from A1 to G50 only. i tried the following
macro, press F4 to state Scrollarea to be A1:G50. However, each time after
i've saved and re-open the file, the setting of Scrollarea in the property
(press F4) is gone and therefore the limit scrollarea is not working:

Private Sub Scroll_Area()
* * Worksheets("Sheet1").ScrollArea = "A1:G50"
End Sub

Please help....

--
exalan