How do I stop the cursor from scrolling?

[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.

 

[Ron de Bruin]

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