Much appreciated, however the data is much much greater than the 46 cells
limit for this option....

"Ragdyer" wrote:

There is another way to set the cell order for data entry.

The sheet does *not* have to be protected with this procedure.

Check out this old link:

http://tinyurl.com/39vzv

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"bobbi120" wrote in message
...
Can I make the tab key in a protected spreadsheet move a cell down in a
instead of across? I cannot use VBA/programming though...or alternatively,
can i set the order of unlocked cells in a protected sheet?