View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Harald Staff Harald Staff is offline
external usenet poster
 
Posts: 1,327
Default Tab to Certain Fields

Hi John

Select A5 and E14. Go menu Format Cells, Protection and unselect Locked.

Now go menu Tools Protection Protect worksheet. Once protected then
tabbing moves between unlocked cells only, the others are write protected.

For your possible followup; can you set the tab order like A5, E14, B6, G2,
.... no, there is no easy or user friendly way to do that. Possible but very
awkward.

HTH. Best wishes Harald

"John" skrev i melding
...
I have a Worksheet where certain fields are filled out is it possible to
automatically move to the next field I want to populate without having to
physically click on the cell I want. Something like Tab? So for example if

I
enter a value in A5 and the next field I want filled out is E14 it jumps

to
it once a value is put in A5?

Thanks