Ok, i did this, & I do want it to automatically come up when the sheet is
open. What does VBA mean? How do i get this to work?
Jo

"Otto Moehrbach" wrote:

The method given you by Eduardo is one way. The only drawback I know of
that method is that the order of cell selection cannot be controlled by you
or the user. Cell selection will be by rows and then by columns.
Another way is to select the cells in which you want the user to enter
data and name that range, say TheRng. The sequence of cell selection by you
when you name the range is the key to the sequence of cell selection by the
user. Here is how you do it. Click on the second cell in the sequence you
want. Now hold down the Ctrl key and select all the other cells in the
sequence you want ending up with the first cell in the sequence. Release
the Ctrl key and name that range. Now if you hit the F5 key, click on
TheRng - OK, all those cells will be selected and the first cell in the
sequence will be the active cell. Hitting the tab key will move the
selection to the next cell in the order you chose. The only drawback to
this method is that the range has to be selected. I don't know how you will
be using this but you might consider VBA to automatically select the range
when the workbook is opened or that sheet is selected. HTH Otto
"Joann" wrote in message
...
I have a worksheet that I am putting together & when I tab through it, I
only
want it to tab to the cells that I need to be completed by others (as
opposed
to going to every cell). Is there a way that i can set this worksheet up
to
where it will only do this?


Thanks!
Jo
I