Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i prevent continued highlighting cells when cursor moves? | New Users to Excel | |||
how to prevent unlimited scrolling in unprotected cells | Excel Discussion (Misc queries) | |||
Move cursor through all unprotected cells in a protected worksheet | Excel Discussion (Misc queries) | |||
How to prevent cursor from moving behind filled cells | Excel Discussion (Misc queries) | |||
CELL PROTECTED IN 2000, UNPROTECTED IN 2003 | Excel Worksheet Functions |