View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default How do I stop the cursor from scrolling?

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.