SUdden change in Tab key behavior..

  • Thread starter Thread starter Greg Little
  • Start date Start date
G

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
 
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
(e-mail address removed)
 
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.
 
Forgot to add that none of the code recently added pertains to protection, as if
that might make a difference :)

Greg
 
Back
Top