Stop Scrolling

Hi Elvin

Your example does work but you have to activate Sheet1 first. Try clicking into Sheet2 then back into Sheet1.

Another place to add the code to is ThisWorkbook
(Double click ThisWorkbook, change from General to Workbook, Open)

Private Sub Workbook_Open()
Worksheets(1).ScrollArea = "a1:m34"
End Sub

Remember to save as a macro enabled workbook when finished or a 97-2003 format.

hope that helps

Cheers
Doug
Best STL