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?

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?

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?

Didn't the last line of the link say:
<<<"If you try more, and run into a problem, post back for work-arounds."
<bg

Well ...
Here's a simple work-around by Dave Peterson to by-pass the limit:

http://tinyurl.com/ypk2j


--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"bobbi120" wrote in message
...
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?