View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
kaininito kaininito is offline
external usenet poster
 
Posts: 3
Default cursor behavious when restricting selection to unlocked cells

Hi

I have created a workbook in which I limit cursor movement to
unprotected
cells, by using the VBA code

With Worksheets(Sheet.Name)
.EnableSelection = xlUnlockedCells
End With

This works fine but the cursor now shows strange behaviour, which is
quite annoying:

*** when the cursor reaches the right-most unprotected cell in a
particular
row, it wraps to the left-most unprotected cell in the next row (i.e.
next
row that contains an unprotected cell)

*** when the cursor reaches the bottom-most unprotected cell in a
particular
column, it wraps to the top-most unprotected cell in the next column
(i.e.
next column that contains an unprotected cell)

Is it possible to prevent this?
I think I am not the only one who often keeps the "up" or the "left"
key pressed until reaching the top/left, but with this cursor behaviour
the cursor jumps to where I donīt want it to go.

Thanks
Kai