Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Joe
 
Posts: n/a
Default Limit cursor range

How can I limit the range a cursor may go?

TIA
  #2   Report Post  
Ron de Bruin
 
Posts: n/a
Default

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" wrote in message ...
How can I limit the range a cursor may go?

TIA



  #3   Report Post  
joe
 
Posts: n/a
Default

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" wrote in

message ...
How can I limit the range a cursor may go?

TIA



.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
What is the limit size for columns in Excel??? Melissa Excel Discussion (Misc queries) 5 May 16th 05 09:29 PM
How do I limit the number of complete sentences in a spreadsheet c sbernard Excel Worksheet Functions 1 February 13th 05 05:26 AM
anyway to limit printing of documents Soe Nandar Excel Discussion (Misc queries) 2 January 26th 05 11:20 PM
Nested IF limit or Open parentheses limit Fred Excel Discussion (Misc queries) 5 December 23rd 04 03:34 PM
Any way to get around the 240-character line limit on text output? awp Excel Discussion (Misc queries) 3 December 14th 04 11:59 PM


All times are GMT +1. The time now is 08:52 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"