View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming
Bertus Theron Bertus Theron is offline
external usenet poster
 
Posts: 3
Default Excel 2000: Unprotected cells - how to prevent cursor from wrapping ???

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 I find the cursor-wrapping behaviour annoying and
confusing, e.g.:
*** 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)

This is especially confusing if the data on the sheet stretches wider and
longer than the screen, because as the cursor moves, you often find it
jumping suddenly and unwanted to the other end of the data. I would rather
prefer the cursor to stop at the edge of the data. How can I achieve the
desired behaviour.

Regards
Bertus