cell content - data entry order by enduser
 

I locked and validated cells in a .xls worksheet for endusers to complete
[credit card application] As i tab through the form to add data....the cells
selected don't go in a chronological order.
Can someone assist in how I fix this issue within Excel.
much appreciated
Tammy

cell content - data entry order by enduser
 

The tabbing in a protected sheet follows standard XL rules. Left to right,
then top to bottom.

Perhaps you need to rearrange the layout of your form?
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Tammy" wrote:

I locked and validated cells in a .xls worksheet for endusers to complete
[credit card application] As i tab through the form to add data....the cells
selected don't go in a chronological order.
Can someone assist in how I fix this issue within Excel.
much appreciated
Tammy

cell content - data entry order by enduser
 

You could use a named range which you would design in the order you want to
move.

See Bob Phillips' site for more.

http://www.xldynamic.com/source/xld.xlFAQ0008.html


Gord Dibben MS Excel MVP

On Wed, 8 Apr 2009 12:01:07 -0700, Tammy
wrote:

I locked and validated cells in a .xls worksheet for endusers to complete
[credit card application] As i tab through the form to add data....the cells
selected don't go in a chronological order.
Can someone assist in how I fix this issue within Excel.
much appreciated
Tammy