scroll limits

  • Thread starter Thread starter dan reighard
  • Start date Start date
D

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
 
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
 
is there a way to prevent scrolling beyond the
limits of a page? i am not an advanced user, i
have never used macros.
Click to expand...

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
 
Back
Top