I have a spread sheet that is used to order supplies. There are two sheets:
Order & Items. The "Items" sheet list the item numbers, product name, qty.
The "Order" sheet allows the user to enter the item number and qty and the
product name is automatically inserted in appropriate cell. Both sheets are
protected, allowing the user, on the Order sheet, to enter item number and
qty.

With all that said, I want to know if there is a way to force the direction
of the "cursor" to move left to right when entering item number and qty?
There are a couple of sections above the order entry section in which the
cursor must move down. However, I need the cursor to change directions when
entering the item number and qty.

I know this can be done universally via the TOOLS OPTIONS EDIT, but I
don't want to make this a universal switch. Just need it for this one
spreadsheet.

Thanks in advance,
Les