How can I limit the range a cursor may go? TIA
R Ron de Bruin Feb 15, 2005 #2 Hi Joe With code you can do this You can use this in the Thisworkbook module for Sheet1 Private Sub Workbook_Open() Sheets("Sheet1").ScrollArea = "A1:AI100" End Sub
Hi Joe With code you can do this You can use this in the Thisworkbook module for Sheet1 Private Sub Workbook_Open() Sheets("Sheet1").ScrollArea = "A1:AI100" End Sub
J joe Feb 15, 2005 #3 Thanks Ron! -----Original Message----- Hi Joe With code you can do this You can use this in the Thisworkbook module for Sheet1 Private Sub Workbook_Open() Sheets("Sheet1").ScrollArea = "A1:AI100" End Sub -- Regards Ron de Bruin http://www.rondebruin.nl "Joe" <[email protected]> wrote in Click to expand... message news:[email protected]...
Thanks Ron! -----Original Message----- Hi Joe With code you can do this You can use this in the Thisworkbook module for Sheet1 Private Sub Workbook_Open() Sheets("Sheet1").ScrollArea = "A1:AI100" End Sub -- Regards Ron de Bruin http://www.rondebruin.nl "Joe" <[email protected]> wrote in Click to expand... message news:[email protected]...