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?