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

When replying, do so in the same thread. By starting a new thread, you lose
information and the rest of use don't know what's going on.

VBA = Visual Basic for Applications.
It's the coding the Microsoft Office (and other applications) can use to
write macros, interact with other applications, and perform subroutines. You
can get to the editor either by pressing Alt+F11, or right-clicking on a
sheet tab and "view code".

In answer to you first main question, I'd simply unprotect (format
cells-protection, unlselect 'locked') the cells you want to Tab to, and then
protect the worksheet.
--
Best Regards,

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


"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
I

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
I

Luke...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

"Luke M" wrote:

When replying, do so in the same thread. By starting a new thread, you lose
information and the rest of use don't know what's going on.

VBA = Visual Basic for Applications.
It's the coding the Microsoft Office (and other applications) can use to
write macros, interact with other applications, and perform subroutines. You
can get to the editor either by pressing Alt+F11, or right-clicking on a
sheet tab and "view code".

In answer to you first main question, I'd simply unprotect (format
cells-protection, unlselect 'locked') the cells you want to Tab to, and then
protect the worksheet.
--
Best Regards,

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


"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
I

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
I

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
I

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
I

Joann
This macro will do what you want. I also added a scroll command to
place the top-left cell of the range at the top-left corner of the screen.
Selecting a range with VBA does not necessarily place the range, or any part
of it, in the visible screen. It does that with the scroll command I added.
Private Sub Workbook_Open()
Range("TheRng5").Select
With ActiveWindow
.ScrollColumn = Range("TheRng5")(1).Column
.ScrollRow = Range("TheRng5")(1).Row
End With
End Sub
Note that this macro must be placed in the Workbook module. To access that
module, right-click on the Excel icon that is immediately to the left of the
word "File" in the menu that runs across the top of your screen, and select
View Code. Paste this macro into that module. "X" out of the module to
return to your sheet. If you are working with Excel 2007 it's a bit more
complicated if you are not familiar with using VBA. In that case, if you
wish, send me your file or a small sample of your file and I'll place the
macro for you. My email address is . Remove
the "extra" from this address. HTH Otto
"Joann" wrote in message
...
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
I