I named this function TheRng5. There is only one worksheet in this file.
When this file or sheet since it is the only one is opened, I want this range
to automatically be selected so that i don't have to hit the F5 key in order
to enable it.

Please help....thanks!
Joann

"Otto Moehrbach" wrote:

Joann
What did you name the range? Do you want the selection made when you
open the workbook (the file), or do you want the selection made when you (or
the user) selects that sheet? What is the name of the sheet? HTH Otto
"Joann" wrote in message
...
I have created this range of cells....what do I need to do in order to
have the worksheet open & have this range selected so that I only tab
through
that range?

Is this where I lock the other cells? I am confused....
Please help....

Jo



"Shane Devenshire" wrote:

Hi,

Please see the answers on your other thread. Don't break up your
threads,
we don't have time to figure out where something came from.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Joann" wrote:

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

Hi,

I'm confused if there's only 1 worksheet in this file then under which
circumstances do you want to goto the named range? The only one i can think
of is when the workbook is opened so maybe this

Private Sub Workbook_Open()
Application.Goto "TheRng5"
End Sub

Mike

"Joann" wrote:

I named this function TheRng5. There is only one worksheet in this file.
When this file or sheet since it is the only one is opened, I want this range
to automatically be selected so that i don't have to hit the F5 key in order
to enable it.

Please help....thanks!
Joann

"Otto Moehrbach" wrote:

Joann
What did you name the range? Do you want the selection made when you
open the workbook (the file), or do you want the selection made when you (or
the user) selects that sheet? What is the name of the sheet? HTH Otto
"Joann" wrote in message
...
I have created this range of cells....what do I need to do in order to
have the worksheet open & have this range selected so that I only tab
through
that range?

Is this where I lock the other cells? I am confused....
Please help....

Jo



"Shane Devenshire" wrote:

Hi,

Please see the answers on your other thread. Don't break up your
threads,
we don't have time to figure out where something came from.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Joann" wrote:

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