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


--
Regards Ron de Bruin
http://www.rondebruin.nl



"Ortho office" <Ortho wrote in message ...
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.