how to prevent unlimited scrolling in unprotected cells

[AAS]

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?

[scottfoxall]

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?