Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Is this weird or what? | Excel Worksheet Functions | |||
Very weird error | Excel Worksheet Functions | |||
Weird | New Users to Excel | |||
weird | Excel Programming | |||
Weird VBA problem | Excel Programming |