SUdden change in Tab key behavior..

[Greg Little]

I have a 14 sheet workbook which is rather heavily reliant on VB. It's in Excel
2002 (XP). I recently added a batch of new code, and now the Tab key will only
move to two cells on the "Setup" sheet. That sheet has 18 cells unlocked, with
the rest of the worksheet locked and protected, so the user can just tab between
the appropriate cells. I'm at a loss for a reason or direction to look. Tried
options>transition, tried options>tab direction. Tried tearing hair...oops, no
hair. TIA for the help.

Greg Little
glittle.at.sprynet.com

[Nick Hodge]

Greg

Have you checked your code hasn't locked your un-locked cells so they then
get locked with protecting the sheets and tab no longer works

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS


"Greg Little" <glittle@sprynet.com> wrote in message
news:hdsva299on51rqip0rplsmb9r7l1i9qagp@4ax.com...
>I have a 14 sheet workbook which is rather heavily reliant on VB. It's in
>Excel
> 2002 (XP). I recently added a batch of new code, and now the Tab key will
> only
> move to two cells on the "Setup" sheet. That sheet has 18 cells unlocked,
> with
> the rest of the worksheet locked and protected, so the user can just tab
> between
> the appropriate cells. I'm at a loss for a reason or direction to look.
> Tried
> options>transition, tried options>tab direction. Tried tearing
> hair...oops, no
> hair. TIA for the help.
>
> Greg Little
> glittle.at.sprynet.com

[Greg Little]

Nope, they show unlocked. That's what really stumps me- I can select the cells
in question with the mouse by clicking on them, but the Tab key won't go to any
of them except the one. When it does, shift-Tab requires two taps to return.
Thanks for the answer.

On Sat, 8 Jul 2006 19:33:53 +0100, "Nick Hodge"
<nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS> wrote:

>Greg
>
>Have you checked your code hasn't locked your un-locked cells so they then
>get locked with protecting the sheets and tab no longer works

[Greg Little]

Forgot to add that none of the code recently added pertains to protection, as if
that might make a difference

Greg

On Sat, 8 Jul 2006 19:33:53 +0100, "Nick Hodge"
<nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS> wrote:

>Greg
>
>Have you checked your code hasn't locked your un-locked cells so they then
>get locked with protecting the sheets and tab no longer works