tab order

  • Thread starter Thread starter Rick
  • Start date Start date
R

Rick

Is there a way to set the order unlocked cells are tabbed
through on a protected worksheet?

Thanks. Rick
 
Rick,

No, you cannot set the tab order of cells on a worksheet.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
You bring up an interesting question.

The two main, non-code procedures, for choosing cells for data entry
(selection), are the "named range" approach, and the "unlocked cell &
protected sheet" approach that you have used.
Where the "unlocked cell" procedure will loop through all the unlocked cells
in the normal tabbed order (row by row), the cell selection in the "named
range" procedure will follow the exact order that the cells were selected
during the creation of the range.
Plus, it is unnecessary for the sheet to be protected for this cell
selection to function.

S0, the direct answer to your question is "Yes", *if* you incorporate
(combine) the "named range" concept with the one that you used.

Which now brings up the question of whether or not you might be satisfied
with using just the "named range" procedure.

Here is a link to an old post which describes "Named Ranges".

http://tinyurl.com/39vzv


--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

Is there a way to set the order unlocked cells are tabbed
through on a protected worksheet?

Thanks. Rick
 
try posting this in the Programing section and ask if you
can record or write a macro for such thing
 
Yes to both!

Go to:
<Insert> <Name> <Define>,
And select the range name in the big window, then,
You can click "Delete",
OR, to edit,
Click in the "RefersTo" box and hit <F2>,
And add or subtract the references that you see there.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


Once you set the range say 'Entry1' , can you either edit
it or delete it?
 
Giving some thought to your question, don't think that there's anything
mysterious about this.

This is a regular performance of XL's, when the focus of cells within a
range, are constricted to that range.

For example, click in any cell and drag to maybe 5 cells wide and 5 cells
deep.
When you release the mouse, the focus for this range is the first cell you
clicked in.
Now, just hold down <Enter>.
See how the focus moves from cell to cell, but *remains* within the range.
At this point, you can make enteies to a cell, hit enter, and continue to
enter data and remain within the range.

This is an *un-named* range, just a selection of cells.
You could do the same thing selecting different, non-contiguous cells, and
enter data.

With the "named range", you're simply, more or less, putting the range of
selected cells into memory, so that you don't have to go through the same
actions, time after time.
Calling up the range by name, is just saving you the effort of reselecting
each and every cell ... each and every time you wish to enter data in a
particular order.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


Yes to both!

Go to:
<Insert> <Name> <Define>,
And select the range name in the big window, then,
You can click "Delete",
OR, to edit,
Click in the "RefersTo" box and hit <F2>,
And add or subtract the references that you see there.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


Once you set the range say 'Entry1' , can you either edit
it or delete it?
 
This was very helpful. Thanks.

Sorry, I missed to ask this. Is it possible to make it a default
setting or something.

thanks again.
-----Original Message-----
Giving some thought to your question, don't think that there's anything
mysterious about this.

This is a regular performance of XL's, when the focus of cells within a
range, are constricted to that range.

For example, click in any cell and drag to maybe 5 cells wide and 5 cells
deep.
When you release the mouse, the focus for this range is the first cell you
clicked in.
Now, just hold down <Enter>.
See how the focus moves from cell to cell, but *remains* within the range.
At this point, you can make enteies to a cell, hit enter, and continue to
enter data and remain within the range.

This is an *un-named* range, just a selection of cells.
You could do the same thing selecting different, non-contiguous cells, and
enter data.

With the "named range", you're simply, more or less, putting the range of
selected cells into memory, so that you don't have to go through the same
actions, time after time.
Calling up the range by name, is just saving you the effort of reselecting
each and every cell ... each and every time you wish to enter data in a
particular order.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


Yes to both!

Go to:
<Insert> <Name> <Define>,
And select the range name in the big window, then,
You can click "Delete",
OR, to edit,
Click in the "RefersTo" box and hit <F2>,
And add or subtract the references that you see there.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


Once you set the range say 'Entry1' , can you either edit
it or delete it?
-----Original Message-----
You bring up an interesting question.

The two main, non-code procedures, for choosing cells
Click to expand...
for
data entry
(selection), are the "named range" approach, and the "unlocked cell &
protected sheet" approach that you have used.
Where the "unlocked cell" procedure will loop through
Click to expand...
all
the unlocked cells
in the normal tabbed order (row by row), the cell selection in the "named
range" procedure will follow the exact order that the cells were selected
during the creation of the range.
Plus, it is unnecessary for the sheet to be protected for this cell
selection to function.

S0, the direct answer to your question is "Yes", *if* you incorporate
(combine) the "named range" concept with the one that
Click to expand...
you
Click to expand...
 
Don't quite understand what you mean by "default setting".

If this or *any* named range is saved as part of a template, when that
template is called up, the range will be included.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
This was very helpful. Thanks.

Sorry, I missed to ask this. Is it possible to make it a default
setting or something.

thanks again.
Click to expand...
 
i meant to say when i open the template it always opens
the named range (so that the employees using the file dont
have to go to the name bar and select the range).

but now that i m thinking of it i guess that i should used
protected sheet method to do this. this is just for
reducing a step for the employees (who are not grt at
excel and one more small step seems like one more big work
to them)
 
You *can* save the template with the range *already selected*.

So, when the user opens (calls up) the template, they see the sheet all
ready for data input, without having to do anything else.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


i meant to say when i open the template it always opens
the named range (so that the employees using the file dont
have to go to the name bar and select the range).

but now that i m thinking of it i guess that i should used
protected sheet method to do this. this is just for
reducing a step for the employees (who are not grt at
excel and one more small step seems like one more big work
to them)
 
Back
Top