Enter doesn’t return to the cell below the starting point anymor e

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jeff - 25 Apr 2008 20:31 GMT

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 Tools>Options>Edit "Move selection after Enter" is
checked, Direction: my options are: Down, Right, Up, or Left; "Down" is
selected.

I also looked at Tools>Options>Transition to make sure "Transition
navigation keys" is unchecked.

What else could be the problem?

Thank you,
Jeff

Reply to this Message

Earl Kiosterud - 26 Apr 2008 00:10 GMT

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.

Signature

Regards from Virginia Beach,

Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------

> This just started happening yesterday...
>
[quoted text clipped - 19 lines]
> Thank you,
> Jeff

Reply to this Message

Jeff - 26 Apr 2008 00:30 GMT

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

> Jeff,
>
[quoted text clipped - 27 lines]
> > Thank you,
> > Jeff

Reply to this Message

Earl Kiosterud - 26 Apr 2008 02:19 GMT

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. :)

Signature

Regards from Virginia Beach,

Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------

> 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.
[quoted text clipped - 35 lines]
>> > Thank you,
>> > Jeff

Reply to this Message