Thanks for your reply - I really appreciated your response.

"Ian" wrote:

You won't be able to move in the order you quoted in your post, but you
could leave the required cells unlocked and tab between them. This method
works by rows, that is, it looks for the next available cell on the current
row and if it doesn't find any tries the next row and so on until it finds
an unlocked cell. If you save the file with N1 selected, it would tab to N7
then C9 and back to N1. Obviously there are more cells you need, but it
might be worth a look.

Select each of the cells you want to populate and set the cell protection to
unlocked (FormatCellsProtection uncheck Locked). Once this is done,
protect the worksheet (ToolsProtectionProtect Sheet). By using tab, you
will automatically jump to the next available cell, those available are the
ones you have unlocked.

--
Ian
--
"J9Y" wrote in message
...
I'm working with an invoice document that someone created on Excel 2003.
It's a great document, but we want to program either the TAB key or the
ENTER
key to move to a different cell within the worksheet. Example: After
typing
the Date, enter automatically to Invoice Number, then enter automatically
to
Company Name, and so on. Is there a way to start at cell N1 ,then program
the Enter key to automatically go to cell N7 after that, then C9 after
that
and so on.

Any information is GREATLY appreciated!