how to prevent unlimited scrolling in unprotected cells
 

I have a set of unprotected cells in an otherwise protected worksheet.
Within this block of unprotected cells, there is no limit to the movement of
the cursor. if i hold down the left arrow, the cursor won't stop at column
A, it will jump to the last unprotected column of the previous row. same
thing happens if i hold down the down arrow, the cursor won't stop at the
bottom of the unprotected section but jumps to the top of the next colum.
how can I stop this from happening?

how to prevent unlimited scrolling in unprotected cells
 

You can do this through the worksheet properties in the VBE.

Open VBA ("Press Alt+F11")

You should then see your workbook in a tree structure on the left hand side.
You may have to expand this out.

Double click the worksheet: example Worksheet("Sheet1")
Then you should see "ScrollArea" on the properties dialog.

If you typed A1:AB100

This would constrain the scrolling to that area.





"AAS" wrote:

I have a set of unprotected cells in an otherwise protected worksheet.
Within this block of unprotected cells, there is no limit to the movement of
the cursor. if i hold down the left arrow, the cursor won't stop at column
A, it will jump to the last unprotected column of the previous row. same
thing happens if i hold down the down arrow, the cursor won't stop at the
bottom of the unprotected section but jumps to the top of the next colum.
how can I stop this from happening?