This seems weird to me
G'day there Peoples,
Whilst investigating my scrolling troubles (outlined in another
post), I took the following actions.
Created a new blank workbook. Removed all AddIns. Selected Row 10,
on first sheet and then down to bottom of sheet. Set selected cells
protection to "Unlocked". I then protected the sheet, ticking only
"Select Unlocked Cells". That way I should have been able to select all
cells in rows below 9.
I had the cursor in some random cell in about row 14, column 5 or
6, and then I pressed the down arrow. The selected cell immediately
jumped to column 1, row 10 (top, left unlocked cell) and refused to move
no matter which arrow key I pressed.
Is this normal? What changes with regard to scrolling when a
worksheet is protected? I have no idea of whether this is something I
can resolve, or whether I just have to leave the whole thing
unprotected. That's not a real good option.
Does anyone know how this is supposed to work?
See ya
Ken McLennan
Qld, Australia
|