scroll limits

[dan reighard]

is there a way to prevent scrolling beyond the limits of a page? i a
not an advanced user, i have never used macros

 

[Ron de Bruin]

Hi Dan

You must run code like this every time you open the workbook
Excel don't save this with the file

A good place is the Workbook open event for example

Try this in the Thisworkbook module for a sheet
with the name Sheet1

Right click on the Excel icon next to File in the menubar
choose view code
paste it in there
Alt-Q to go back to Excel

Private Sub Workbook_Open()
Worksheets("sheet1").ScrollArea = "a1:m50"
End Sub

 

[Jordon]

is there a way to prevent scrolling beyond the
limits of a page? i am not an advanced user, i
have never used macros.

You could click on the row number that's one row
below the last row of data, then hold down the
shift key and tap the end key and then the down
arrow key. Right-click the selection and select
Hide. Do the same with the columns.

This won't be practical if your rows and columns
increase frequently.

Jordon