This just started happening yesterday...

My documents are protected as "Select unlocked cells", which is how Ive
always protected my documents. By the way, Im using Excel 2003.

Anyway, when I hit enter after tabbing through cells it doesnt return to
the cell below the staring point anymore. I tried this again in old workbooks
and blank workbooks but its the same problem.

The only way it will work when protected is if I have "select locked cells"
checked (which I dont like but can live with).

I already checked in ToolsOptionsEdit "Move selection after Enter" is
checked, Direction: my options a Down, Right, Up, or Left; "Down" is
selected.

I also looked at ToolsOptionsTransition to make sure "Transition
navigation keys" is unchecked.

What else could be the problem?

Thank you,
Jeff

Jeff,

I had a similar problem recently. Worksheet protected with only select unlocked cells
allowed. XL 2003. In my case, using the arrow keys made it go nuts, jumping around and
sometimes locking up Excel. So did the Enter key. If I allowed selection of locked cells,
no failure. I was able to confirm this behavior on an XL2000 machine, and Jim Cone confirmed
it on XL 2002 and 2003. Nothing in the knowledge base about it, but if there was, it'd
probably be the usual "don't do that" answer.
--
Regards from Virginia Beach,

Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------
"Jeff" wrote in message
...
This just started happening yesterday...

My documents are protected as "Select unlocked cells", which is how I've
always protected my documents. By the way, I'm using Excel 2003.

Anyway, when I hit enter after tabbing through cells it doesn't return to
the cell below the staring point anymore. I tried this again in old workbooks
and blank workbooks but it's the same problem.

The only way it will work when protected is if I have "select locked cells"
checked (which I don't like but can live with).

I already checked in ToolsOptionsEdit "Move selection after Enter" is
checked, Direction: my options a Down, Right, Up, or Left; "Down" is
selected.

I also looked at ToolsOptionsTransition to make sure "Transition
navigation keys" is unchecked.

What else could be the problem?

Thank you,
Jeff

Thanks Earl, that's what I was afraid of. Oh well, maybe I will have to live
with it then. Or maybe it will just go away.

Thanks again,
Jeff

"Earl Kiosterud" wrote:

Jeff,

I had a similar problem recently. Worksheet protected with only select unlocked cells
allowed. XL 2003. In my case, using the arrow keys made it go nuts, jumping around and
sometimes locking up Excel. So did the Enter key. If I allowed selection of locked cells,
no failure. I was able to confirm this behavior on an XL2000 machine, and Jim Cone confirmed
it on XL 2002 and 2003. Nothing in the knowledge base about it, but if there was, it'd
probably be the usual "don't do that" answer.
--
Regards from Virginia Beach,

Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------
"Jeff" wrote in message
...
This just started happening yesterday...

My documents are protected as "Select unlocked cells", which is how I've
always protected my documents. By the way, I'm using Excel 2003.

Anyway, when I hit enter after tabbing through cells it doesn't return to
the cell below the staring point anymore. I tried this again in old workbooks
and blank workbooks but it's the same problem.

The only way it will work when protected is if I have "select locked cells"
checked (which I don't like but can live with).

I already checked in ToolsOptionsEdit "Move selection after Enter" is
checked, Direction: my options a Down, Right, Up, or Left; "Down" is
selected.

I also looked at ToolsOptionsTransition to make sure "Transition
navigation keys" is unchecked.

What else could be the problem?

Thank you,
Jeff

Jeff,

I had to solve it by also allowing selection of locked cells. Less useful for the user, but
it works. I lost a lot of time on a simple project a few weeks ago struggling with this.
And it was urgent. I was working on a Sunday. :)
--
Regards from Virginia Beach,

Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------
"Jeff" wrote in message
...
Thanks Earl, that's what I was afraid of. Oh well, maybe I will have to live
with it then. Or maybe it will just go away.

Thanks again,
Jeff

"Earl Kiosterud" wrote:

Jeff,

I had a similar problem recently. Worksheet protected with only select unlocked cells
allowed. XL 2003. In my case, using the arrow keys made it go nuts, jumping around and
sometimes locking up Excel. So did the Enter key. If I allowed selection of locked
cells,
no failure. I was able to confirm this behavior on an XL2000 machine, and Jim Cone
confirmed
it on XL 2002 and 2003. Nothing in the knowledge base about it, but if there was, it'd
probably be the usual "don't do that" answer.
--
Regards from Virginia Beach,

Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------
"Jeff" wrote in message
...
This just started happening yesterday...

My documents are protected as "Select unlocked cells", which is how I've
always protected my documents. By the way, I'm using Excel 2003.

Anyway, when I hit enter after tabbing through cells it doesn't return to
the cell below the staring point anymore. I tried this again in old workbooks
and blank workbooks but it's the same problem.

The only way it will work when protected is if I have "select locked cells"
checked (which I don't like but can live with).

I already checked in ToolsOptionsEdit "Move selection after Enter" is
checked, Direction: my options a Down, Right, Up, or Left; "Down" is
selected.

I also looked at ToolsOptionsTransition to make sure "Transition
navigation keys" is unchecked.

What else could be the problem?

Thank you,
Jeff