how do I change default limits?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'd like to set the limits of my worksheets to maybe 5 rows after the last entry, so that when I scroll to the bottom, I'm not scrolling to 65,000.

Is there a way to do this in Excel 2002?

Thanks,
 
One thing you can do is to simply "Hide" all the rows and columns you don't
want to see.........Highlight the unwanted rows, Right-click > choose
Hide..........then repeat for the unwanted columns..........then you can
adjust the column widths and row heights to fill the screen, if you
wish............

Vaya con Dios,
Chuck, CABGx3



dot said:
I'd like to set the limits of my worksheets to maybe 5 rows after the last
Click to expand...
entry, so that when I scroll to the bottom, I'm not scrolling to 65,000.
 
In addition to hiding the rows, put this in your ThisWorkbook code
module (right-click the workbook titlebar and choose View Code):

Private Sub Workbook_Open()
With Sheets("Sheet1")
.ScrollArea = .Range("A1:A" & .Range( _
"A" & .Rows.Count).End(xlUp).Row + 5).EntireRow.Address
End With
End Sub

This will keep the user from scrolling
 
Back
Top