Thread
:
How do I stop the cursor from scrolling?
View Single Post
#
2
Posted to microsoft.public.excel.programming
Ron de Bruin
external usenet poster
Posts: 11,123
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.
Reply With Quote
Ron de Bruin
View Public Profile
Find all posts by Ron de Bruin