Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
prevent cells highlighting | Excel Discussion (Misc queries) | |||
can i prevent duplications in cells | Excel Worksheet Functions | |||
Keep certain cells visible when scrolling, not just rows or colum | Excel Worksheet Functions | |||
Can some cells remain unprotected in a protected spreadsheet ? | Excel Discussion (Misc queries) | |||
Order of selecting unprotected cells | Excel Discussion (Misc queries) |