Cell tab order

[Craig]

Is there a way to control the order you tab to specific
cells? For example, I would like to hit tab to jump to 25
specific cells in this order: A1, B14, J5, H24, and A15
etc. I did select the second cell I wanted in the range
then CRTL + click my way through the range, ending with
the first cell in the range. Then I tried naming the
range under insert, Name, Define>OK but I received the
error message: [Your formula contains an invalid external
reference to a worksheet. Verify that the path, workbook,
and range or cell reference are correct and try again.]

I am not referencing an external worksheet or workbook. I
am trying to do this all on one tab.

 

[Charlie]

Craig,

Why not protect the worksheet and unlock the cells needing
data entry? By doing this the cursor will only tab to the
next unprotected cell.

Charlie O'Neill

 

[~Craig]

Thank you Charlie.

The problem I have is the order that they requested the
tabs in is non-linear. For example, A1, A7, G6, A3, B6, C9.

Your suggestion works great for linear tabbing.

Craig

-----Original Message-----
Craig,

Why not protect the worksheet and unlock the cells needing
data entry? By doing this the cursor will only tab to the
next unprotected cell.

Charlie O'Neill

-----Original Message-----
Is there a way to control the order you tab to specific
cells? For example, I would like to hit tab to jump to 25
specific cells in this order: A1, B14, J5, H24, and A15
etc. I did select the second cell I wanted in the range
then CRTL + click my way through the range, ending with
the first cell in the range. Then I tried naming the
range under insert, Name, Define>OK but I received the
error message: [Your formula contains an invalid external
reference to a worksheet. Verify that the path, workbook,
and range or cell reference are correct and try again.]

I am not referencing an external worksheet or workbook. I
am trying to do this all on one tab.

.

.