Why can't I tab?

[Greg Little]

Why can't I Tab to cells when I can select them with the mouse? The page
is protected, the cells are unlocked. I'm at a loss. The Workbook is in Excel
XP, however with Excel 2000, same results. TIA for any help.

Greg Little
glittle*at*sprynet*dot*com

[NickHK]

Greg,
Tab, arrow keys, enter all work on unlocked cells on protected sheets; XL2K.
Corrupt WB, dodgy keyboard ??

NickHK

"Greg Little" <[email protected]> wrote in message
news:[email protected]...
> Why can't I Tab to cells when I can select them with the mouse? The page
> is protected, the cells are unlocked. I'm at a loss. The Workbook is in
Excel
> XP, however with Excel 2000, same results. TIA for any help.
>
> Greg Little
> glittle*at*sprynet*dot*com

[Greg Little]

I'm thinking I will simply write off that version and go back to a known good,
rewrite the new code and see what happens.... Thanks for the information, it
rather confirms what I thought.

Greg

On Thu, 13 Jul 2006 10:32:27 +0800, "NickHK" <[email protected]> wrote:

>Greg,
>Tab, arrow keys, enter all work on unlocked cells on protected sheets; XL2K.
>Corrupt WB, dodgy keyboard ??
>
>NickHK
>
>"Greg Little" <[email protected]> wrote in message
>news:[email protected]...
>> Why can't I Tab to cells when I can select them with the mouse? The page
>> is protected, the cells are unlocked. I'm at a loss. The Workbook is in
>Excel
>> XP, however with Excel 2000, same results. TIA for any help.
>>
>> Greg Little
>> glittle*at*sprynet*dot*com
>

[richardcranney]

Hi,

If you are actively in a cell (ie you are writing a formula) and try to tab from there, In my version of Excel, it doesnt let you Tab, dont know if this is what you mean.

[Greg Little]

Well, just in case...I have tracked down my own error(?). On the offending
sheet, there are 15 cells, some merged, which are accessible. The rest are
locked and/or hidden. I was using one of the locked&hidden cells to store a
password, and as soon as the password was entered, the tab problem arose. And it
was not un-doable. Deleting or clearing all the offending cell would not correct
the problem. Thanks for the help, here's the answer just in case someone else
manages to do it to themselves.

Greg Little
glittle*at*sprynet*dot*com