Protection causes unwanted cursor movement

[millsy]

I have set up a spreadsheet in Excel 2003 with some cells protected an
others not. When I turn on the worksheet protection I select th
option not to allow the user to select protected cells. This cause
the cursor to skip over protected cells which is what I want it to do.

My problem is that if I enter a value in a cell and press enter, th
cursor skips down one cell. This is not what I want. I have looked i
the options menu and the "Move Selection After Enter" option has no
been checked. If I turn off protection the cursor does not move afte
pressing enter.

Any ideas anyone

 

[Dave Peterson]

I use xl2002 and the only way I could duplicate this was to select those cells
first--then hitting enter (with MSAE turned off) would take me to the next cell
in that selection.

Any chance that's what you have?

 

[Earl Kiosterud]

Millsy,

Hmmm. Excel 2002 behaves in the same way. If you set Move Selection to any
direction, such as right, then deselect the option, it still moves right
when the sheet is protected (but not when it isn't). This looks like a bug.
You can hold the cell pointer still with Ctrl-Enter, as usual (not
applicable if multiple cells are selected, as it will put the value in all
the selected cells). But that's probably more than you're willing to mess
with.

If this is important, and you're willing to use an event macro, we can
probably write one that will keep the cell pointer still.

 

[Dave Peterson]

Ok. What am I doing differently?

I selected a range of cells:
E4:k8
I unlocked those cells
I changed the MSAE to right
I protected the worksheet
I changed the MSAE to off.

xl didn't move right when I entered a value into one of those cells.

(xl2002 sp2)

 

[Debra Dalgleish]

When you protected the worksheet, did you allow users to select unlocked
cell, but not locked cells?

 

[Dave Peterson]

No. Sigh.

I remember other posts that describe this same problem.

(well, now I do.)

Thanks for the reminder/correction.

And sorry to Millsy, too.