Tab down instead of right in protected cells

  • Thread starter Ingibjorg Hinriksdottir
  • Start date
I

Ingibjorg Hinriksdottir

Is there a way to decide the tab order in a worksheet when certain cells has
been locked and protected? I know it is possible in Access, what about Excel
2003?
 
J

Jim Rech

what about Excel 2003?

No. Right and then Down 24/7.

--
Jim
"Ingibjorg Hinriksdottir" <[email protected]>
wrote in message | Is there a way to decide the tab order in a worksheet when certain cells
has
| been locked and protected? I know it is possible in Access, what about
Excel
| 2003?
 
J

Jim May

a stretch, but here's a small sample of restricting tab order
in excel.

Define a range MyTabOrder
In RefersTo box put:
=Sheet1!$C$1,Sheet1!$D$10,Sheet1!$F$11,Sheet1!$G$10
When you want to invoke it, pull down the ranged name box and select it;
it's made active.
HTH
 
J

Jim Rech

It's true - if you pre-select the cells then Tab will move among the cells
in the order you selected them. And if you assign a name and then select
via the name, Tab moves in the order the cells appear in the name
definition. That's a good workaround.

--
Jim
|a stretch, but here's a small sample of restricting tab order
| in excel.
|
| Define a range MyTabOrder
| In RefersTo box put:
| =Sheet1!$C$1,Sheet1!$D$10,Sheet1!$F$11,Sheet1!$G$10
| When you want to invoke it, pull down the ranged name box and select it;
| it's made active.
| HTH
|
| | >>> what about Excel 2003?
| >
| > No. Right and then Down 24/7.
| >
| > --
| > Jim
| > "Ingibjorg Hinriksdottir"
| > <[email protected]>
| > wrote in message
| > | > | Is there a way to decide the tab order in a worksheet when certain
cells
| > has
| > | been locked and protected? I know it is possible in Access, what about
| > Excel
| > | 2003?
| >
| >
|
|
 
Top