How do I stop the cursor from scrolling?

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

Guest

How do I stop the cursor from scrolling to the right in Excell? I have a
year's calendar on a spreadsheet for a medical office's appointment book. I
want a "hard stop" (my phrasing) at the end of my input in column AI, not go
on to infinity. I want it to behave the same way as scrolling to the left
when you can't go to the left of column A.
 
Hi Ortho

You can use this in the Thisworkbook module for Sheet1

Private Sub Workbook_Open()
Sheets("Sheet1").ScrollArea = "A1:AI100"
End Sub

Or select all the columns to the right of AI and Hide them
 
Back
Top