Just a quick one.

In a worksheet, pressing the tab key allows the user to
move to the next cell to the right. Is there a way to
restrict which cells the user can go to? For example the
cursor starts off in cell A5 and when the tab key is hit
the cursor moves to cell A10 instead of B5?

Cheers,
D

Just a thought, you might want to pop the following line
in somewhere to disable to tabbing

Application.OnKey "{TAB}"

Cheers.

-----Original Message-----
Just a quick one.

In a worksheet, pressing the tab key allows the user to
move to the next cell to the right. Is there a way to
restrict which cells the user can go to? For example the
cursor starts off in cell A5 and when the tab key is hit
the cursor moves to cell A10 instead of B5?

Cheers,
D

.

See alternate methods in answer to your first post.

Gord Dibben Excel MVP - XL97 SR2 & XL2002

On Tue, 15 Jul 2003 20:03:52 -0700, "Darren O'Connell"
wrote:

Just a quick one.

In a worksheet, pressing the tab key allows the user to
move to the next cell to the right. Is there a way to
restrict which cells the user can go to? For example the
cursor starts off in cell A5 and when the tab key is hit
the cursor moves to cell A10 instead of B5?

Cheers,
D

I think you read Gord's intent wrong. I read it as a reminder to the original
poster that he/she has another response and they might like to go back there and
look at it.



Don wrote:

Nice to see the friendlyness in this forum.
These forums are for helping other's, and sharing ideas.
Just because another person puts forward a possible
solution (no matter how incorrect it is), doesn't mean you
should blatantly criticise them.

You should think about getting some manners before you
post again.

-----Original Message-----
See alternate methods in answer to your first post.

Gord Dibben Excel MVP - XL97 SR2 & XL2002

On Tue, 15 Jul 2003 20:03:52 -0700, "Darren O'Connell"
wrote:

Just a quick one.

In a worksheet, pressing the tab key allows the user to
move to the next cell to the right. Is there a way to
restrict which cells the user can go to? For example
the
cursor starts off in cell A5 and when the tab key is
hit
the cursor moves to cell A10 instead of B5?

Cheers,
D

.


--

Dave Peterson

Don

Dave is correct stating my intent. I criticised no one, blatantly or
otherwise.

Your perception of events, of course, is strictly that.......yours, but it
serves as a reminder to us all that one man's Mede is another man's Persian.

Gord



On Tue, 15 Jul 2003 23:23:21 -0500, Dave Peterson wrote:

I think you read Gord's intent wrong. I read it as a reminder to the original
poster that he/she has another response and they might like to go back there and
look at it.



Don wrote:

Nice to see the friendlyness in this forum.
These forums are for helping other's, and sharing ideas.
Just because another person puts forward a possible
solution (no matter how incorrect it is), doesn't mean you
should blatantly criticise them.

You should think about getting some manners before you
post again.

-----Original Message-----
See alternate methods in answer to your first post.

Gord Dibben Excel MVP - XL97 SR2 & XL2002

On Tue, 15 Jul 2003 20:03:52 -0700, "Darren O'Connell"
wrote:

Just a quick one.

In a worksheet, pressing the tab key allows the user to
move to the next cell to the right. Is there a way to
restrict which cells the user can go to? For example
the
cursor starts off in cell A5 and when the tab key is
hit
the cursor moves to cell A10 instead of B5?

Cheers,
D

.