Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
My cursor always in selection mode,wat about other cursor option | Excel Discussion (Misc queries) | |||
Restricting cell selection | Excel Discussion (Misc queries) | |||
Moving from unlocked cells to unlocked cells in an excel form | Excel Worksheet Functions | |||
Locked spreadsheet, move cursor only to unlocked cells? | Excel Worksheet Functions | |||
Changing active selection cursor | Excel Discussion (Misc queries) |