![]() |
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 |
All times are GMT +1. The time now is 10:39 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com