Protected sheet disables arrow key movement

[Rehnahvah]

Hello all,

I have a heavily coded Excel workbook that has a worksheet that displays information (that is locked) and cells that are unlocked for user entry. Everything worked well, but at some point, the sheet began preventing consistent navigation using the arrow keys.

While the sheet is protected, you can click on any unlocked cell and it selects appropriately. You can Page Up and Down (Scroll Lock is not on). If one of the unlocked cells is selected the right, up, and down arrows are pressed, nothing happens. If the left arrow is pressed a couple of times, the selection changes and then you can use the left and right arrows to move horizontally, but the up/down arrows still don't function.

When the sheet is unprotected, all of the arrow keys work fine. I cannot find any coding that would have disabled normal selection. If anyone has run into similar problems, I would appreciate your insight.

 

[ajetrumpet]

check the protection again. see what's available and what's not. does print area have anything to do with this? are certain cells targeted for locking? that could also be a prolbem.

 

[Rehnahvah]

check the protection again. see what's available and what's not. does print area have anything to do with this? are certain cells targeted for locking? that could also be a prolbem.

Thanks for the reply!

Some cells in the rows are locked for data security reasons, however none of the cells in area in which I would like to navigate are locked (columns A-M are locked, columns N-U are not). I also cleared the print area and made sure that "Select unlocked cells" was selected in the protection options.

In addition to the symptoms I described above, I noticed that after the initial protection, I can click on cells to select them (i.e., the active cell address changes in the field in the upper right), but the border that normally appears around the active cell does not appear. If I unprotect and re-protect the sheet manually, then the selection border appears like normal, but the arrows still will not navigate correctly.