Enter, tab, arrow keys aren't allowing me to move to other cells

[Greg]

I have a multi page worksheet with functions throughout.
It has one sheet of inputs, other sheets hidden, input & answer sheets are
protected.
The Input sheet, several cells are available to input.
Yesterday I could move around with the enter key, tab, and arrows.
Today for some reason, the enter, tab, and arrow keys will not move me around.
I made sure all input cells and function formatted linked cells are unlocked
and unprotected.
I have to click into another cell to move.
***I reboot, and the keys still don't work.***
I have been through all the options settings, can't find the answer.
Help!

[Peo Sjoblom]

What do you mean? If you press tab nothing happens or it does move but not as
expected, if so uncheck transition navigation keys under
tools>options>transition
Since you already checked options I assume you checked the enter key
movements under tools>options>edit? You could also have a macro that turns
off different keys but it sounds unlikkely

Regards,

Peo Sjoblom

"Greg" wrote:

> I have a multi page worksheet with functions throughout.
> It has one sheet of inputs, other sheets hidden, input & answer sheets are
> protected.
> The Input sheet, several cells are available to input.
> Yesterday I could move around with the enter key, tab, and arrows.
> Today for some reason, the enter, tab, and arrow keys will not move me around.
> I made sure all input cells and function formatted linked cells are unlocked
> and unprotected.
> I have to click into another cell to move.
> ***I reboot, and the keys still don't work.***
> I have been through all the options settings, can't find the answer.
> Help!

[greg]

Hey, thanks for quick reply.
To answer your question, the keys do nothing when I hit them.

BUT, I can narrow in on my problem even further.
I noticed the keys do not work after I protect the sheet.
What does this tell you?
-GReg

"Peo Sjoblom" wrote:

> What do you mean? If you press tab nothing happens or it does move but not as
> expected, if so uncheck transition navigation keys under
> tools>options>transition
> Since you already checked options I assume you checked the enter key
> movements under tools>options>edit? You could also have a macro that turns
> off different keys but it sounds unlikkely
>
> Regards,
>
> Peo Sjoblom
>
> "Greg" wrote:
>
> > I have a multi page worksheet with functions throughout.
> > It has one sheet of inputs, other sheets hidden, input & answer sheets are
> > protected.
> > The Input sheet, several cells are available to input.
> > Yesterday I could move around with the enter key, tab, and arrows.
> > Today for some reason, the enter, tab, and arrow keys will not move me around.
> > I made sure all input cells and function formatted linked cells are unlocked
> > and unprotected.
> > I have to click into another cell to move.
> > ***I reboot, and the keys still don't work.***
> > I have been through all the options settings, can't find the answer.
> > Help!

[nikila40]

Hi Greg!

I am having the same problem, but only with my "enter" key. Before when I
would hit "enter", the cursor would move to the first cell in the next row.
Now - nothing - the cursor stays in the same cell. I have to use my arrow
keys to move around. If you find an answer, post!

Thanks....

"Greg" wrote:

> I have a multi page worksheet with functions throughout.
> It has one sheet of inputs, other sheets hidden, input & answer sheets are
> protected.
> The Input sheet, several cells are available to input.
> Yesterday I could move around with the enter key, tab, and arrows.
> Today for some reason, the enter, tab, and arrow keys will not move me around.
> I made sure all input cells and function formatted linked cells are unlocked
> and unprotected.
> I have to click into another cell to move.
> ***I reboot, and the keys still don't work.***
> I have been through all the options settings, can't find the answer.
> Help!

[nikila40]

THAT WAS IT!! Your response fixed my problem with the "enter" key, Peo!
Thanks....

"Peo Sjoblom" wrote:

> What do you mean? If you press tab nothing happens or it does move but not as
> expected, if so uncheck transition navigation keys under
> tools>options>transition
> Since you already checked options I assume you checked the enter key
> movements under tools>options>edit? You could also have a macro that turns
> off different keys but it sounds unlikkely
>
> Regards,
>
> Peo Sjoblom
>
> "Greg" wrote:
>
> > I have a multi page worksheet with functions throughout.
> > It has one sheet of inputs, other sheets hidden, input & answer sheets are
> > protected.
> > The Input sheet, several cells are available to input.
> > Yesterday I could move around with the enter key, tab, and arrows.
> > Today for some reason, the enter, tab, and arrow keys will not move me around.
> > I made sure all input cells and function formatted linked cells are unlocked
> > and unprotected.
> > I have to click into another cell to move.
> > ***I reboot, and the keys still don't work.***
> > I have been through all the options settings, can't find the answer.
> > Help!

[Ron Rosenfeld]

On Tue, 24 May 2005 11:08:03 -0700, "Greg" <Greg@discussions.microsoft.com>
wrote:

>I have a multi page worksheet with functions throughout.
>It has one sheet of inputs, other sheets hidden, input & answer sheets are
>protected.
>The Input sheet, several cells are available to input.
>Yesterday I could move around with the enter key, tab, and arrows.
>Today for some reason, the enter, tab, and arrow keys will not move me around.
>I made sure all input cells and function formatted linked cells are unlocked
>and unprotected.
>I have to click into another cell to move.
>***I reboot, and the keys still don't work.***
>I have been through all the options settings, can't find the answer.
>Help!

Interesting.

The other day I had a similar problem with my arrow keys. They would scroll
the worksheet, but would not move me from cell to cell.

My options had not been changed.

In my case, the problem turned out to be that I had inadvertently pressed the
"scroll lock" button. But this did not affect the enter or tab keys.


--ron

[greg]

Peo,
I noticed this only happens when I have the sheet protected.
When I unprotect the sheet, the keys work.
What can you gather from this?
-Greg


"Peo Sjoblom" wrote:

> What do you mean? If you press tab nothing happens or it does move but not as
> expected, if so uncheck transition navigation keys under
> tools>options>transition
> Since you already checked options I assume you checked the enter key
> movements under tools>options>edit? You could also have a macro that turns
> off different keys but it sounds unlikkely
>
> Regards,
>
> Peo Sjoblom
>
> "Greg" wrote:
>
> > I have a multi page worksheet with functions throughout.
> > It has one sheet of inputs, other sheets hidden, input & answer sheets are
> > protected.
> > The Input sheet, several cells are available to input.
> > Yesterday I could move around with the enter key, tab, and arrows.
> > Today for some reason, the enter, tab, and arrow keys will not move me around.
> > I made sure all input cells and function formatted linked cells are unlocked
> > and unprotected.
> > I have to click into another cell to move.
> > ***I reboot, and the keys still don't work.***
> > I have been through all the options settings, can't find the answer.
> > Help!