LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default cursor behavious when restricting selection to unlocked cells

When the cursor is, for example in row 20 and I want to go to row 1, I
want to be able to keep the "up" direction key pressed until reaching
row 1.

With EnableSelection = xlUnlockedCells the cursor does not stop at the
top of the page (row 1). Once the cursor is in row 1 and "up" is
pressed again, it jumps down to row 200 (for example).

Same for column A, if the "left" key is pressed with the cursor in
column A, it jumps to column AH (for example).

Kai



 
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
My cursor always in selection mode,wat about other cursor option Deepu[_2_] Excel Discussion (Misc queries) 1 March 2nd 10 01:05 AM
Restricting cell selection Jemwig Excel Discussion (Misc queries) 3 March 16th 09 03:27 PM
Moving from unlocked cells to unlocked cells in an excel form Stacey Lee Excel Worksheet Functions 1 April 24th 06 08:44 PM
Locked spreadsheet, move cursor only to unlocked cells? dhilligoss Excel Worksheet Functions 1 December 5th 05 02:29 PM
Changing active selection cursor Mistaken Creation Excel Discussion (Misc queries) 3 May 27th 05 10:06 PM


All times are GMT +1. The time now is 04:34 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"