In a protected worksheet, I want to enter a single digit in an unprotected
cell, then have the cursor move automatically to the next unprotected cell.
How can I do this?
---Patrick Riley

I guess I'm confused. If you've deselected the "LOCKED" value on the
protection tab of the format cells command and then protected the sheet, it
should do exactly what you want.



"Patrick Riley" wrote:

In a protected worksheet, I want to enter a single digit in an unprotected
cell, then have the cursor move automatically to the next unprotected cell.
How can I do this?
---Patrick Riley

Barb

Patrick wants to move to next cell without hitting Tab, ENTER or Arrow key.

i.e. type a digit and have Excel jump to next cell with no futher action from
user.


Gord Dibben MS Excel MVP

On Mon, 2 Apr 2007 17:54:01 -0700, Barb Reinhardt
wrote:

I guess I'm confused. If you've deselected the "LOCKED" value on the
protection tab of the format cells command and then protected the sheet, it
should do exactly what you want.



"Patrick Riley" wrote:

In a protected worksheet, I want to enter a single digit in an unprotected
cell, then have the cursor move automatically to the next unprotected cell.
How can I do this?
---Patrick Riley

I see. Is there a way to do that? I'm not aware of one.

"Gord Dibben" wrote:

Barb

Patrick wants to move to next cell without hitting Tab, ENTER or Arrow key.

i.e. type a digit and have Excel jump to next cell with no futher action from
user.


Gord Dibben MS Excel MVP

On Mon, 2 Apr 2007 17:54:01 -0700, Barb Reinhardt
wrote:

I guess I'm confused. If you've deselected the "LOCKED" value on the
protection tab of the format cells command and then protected the sheet, it
should do exactly what you want.



"Patrick Riley" wrote:

In a protected worksheet, I want to enter a single digit in an unprotected
cell, then have the cursor move automatically to the next unprotected cell.
How can I do this?
---Patrick Riley

patrick -
then how in the world would excel know you are FINISHED typing?
is it jumping after 1 character is entered? 2? 3? 10?
if you want it after just one character, i guess you could do it with
a worksheet_change macro.
susan


On Apr 2, 11:29 pm, Gord Dibben <gorddibbATshawDOTca wrote:
Barb

Patrick wants to move to next cell without hitting Tab, ENTER or Arrow key.

i.e. type a digit and have Excel jump to next cell with no futher action from
user.

Gord Dibben MS Excel MVP

On Mon, 2 Apr 2007 17:54:01 -0700, Barb Reinhardt



wrote:
I guess I'm confused. If you've deselected the "LOCKED" value on the
protection tab of the format cells command and then protected the sheet, it
should do exactly what you want.

"Patrick Riley" wrote:

In a protected worksheet, I want to enter a single digit in an unprotected
cell, then have the cursor move automatically to the next unprotected cell.
How can I do this?
---Patrick Riley- Hide quoted text -

- Show quoted text -

On Apr 2, 11:29 pm, Gord Dibben <gorddibbATshawDOTca wrote:
Barb

Patrick wants to move to next cell without hitting Tab, ENTER or Arrow key.

i.e. type a digit and have Excel jump to next cell with no futher action from
user.

Gord Dibben MS Excel MVP

On Mon, 2 Apr 2007 17:54:01 -0700, Barb Reinhardt



wrote:
I guess I'm confused. If you've deselected the "LOCKED" value on the
protection tab of the format cells command and then protected the sheet, it
should do exactly what you want.

"Patrick Riley" wrote:

In a protected worksheet, I want to enter a single digit in an unprotected
cell, then have the cursor move automatically to the next unprotected cell.
How can I do this?
---Patrick Riley- Hide quoted text -

- Show quoted text -

Column width sets how many characters the cell can contain. So format
the width of the column to 1. Then just type your number and it will
automatically move to the next cell (either up or down, however you
choose excel to react).

Dorak:
I set column-width to 1, but still got no automatic advancement to the next
(unprotected) cell after typing in a digit. Also, the typed-in digit was not
visible on-screen, even when I set Zoom to 300 %.

"Dorak" wrote:

On Apr 2, 11:29 pm, Gord Dibben <gorddibbATshawDOTca wrote:
Barb

Patrick wants to move to next cell without hitting Tab, ENTER or Arrow key.

i.e. type a digit and have Excel jump to next cell with no futher action from
user.

Gord Dibben MS Excel MVP

On Mon, 2 Apr 2007 17:54:01 -0700, Barb Reinhardt



wrote:
I guess I'm confused. If you've deselected the "LOCKED" value on the
protection tab of the format cells command and then protected the sheet, it
should do exactly what you want.

"Patrick Riley" wrote:

In a protected worksheet, I want to enter a single digit in an unprotected
cell, then have the cursor move automatically to the next unprotected cell.
How can I do this?
---Patrick Riley- Hide quoted text -

- Show quoted text -

Column width sets how many characters the cell can contain. So format
the width of the column to 1. Then just type your number and it will
automatically move to the next cell (either up or down, however you
choose excel to react).

dorak -
i set my column width to 1 & tried this.
with both text & numbers, it doesn't automatically move to the next
cell - it just sits there while you type in more (which you can't
see).
do you have something turned on that i don't have turned on that would
make this happen?
susan



Column width sets how many characters the cell can contain. So format
the width of the column to 1. Then just type your number and it will
automatically move to the next cell (either up or down, however you
choose excel to react).- Hide quoted text -

- Show quoted text -

i tried 2 other ways:
a macro:

Sub Worksheet_Change(ByVal Target As Range)

If ActiveCell.Characters.Count = 1 Then
ActiveCell.Offset(1, 0).Select
End If

End Sub

it doesn't work because the characters.count doesn't happen until
AFTER you exit the cell - before you exit the cell, excel doesn't know
there's anything there. it's empty. the only way to exit the cell is
by hitting enter or an arrow.

i also tried validation & locked a range of cells so that the input
had to be <10 (thereby being a single-digit number), but again, that
doesn't trigger until you exit the cell.

i am going to look & see if there is a keystroke_click event.......
susan


On Apr 3, 10:44 am, "Susan" wrote:
dorak -
i set my column width to 1 & tried this.
with both text & numbers, it doesn't automatically move to the next
cell - it just sits there while you type in more (which you can't
see).
do you have something turned on that i don't have turned on that would
make this happen?
susan





Column width sets how many characters the cell can contain. So format
the width of the column to 1. Then just type your number and it will
automatically move to the next cell (either up or down, however you
choose excel to react).- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -

Gord:
Thank you for more clearly articulating my request. Yes, I wanted the move
to the next cell to occur without hitting TAB, ENTER, or arrow key.
As you (responding to a slightly-differently worded query) and Susan have
now stated, Excel could not know when I had finished data entry for a cell,
thus would have no clue as to when to exit.
Thanx to all who responded.

"Gord Dibben" wrote:

Barb

Patrick wants to move to next cell without hitting Tab, ENTER or Arrow key.

i.e. type a digit and have Excel jump to next cell with no futher action from
user.


Gord Dibben MS Excel MVP

On Mon, 2 Apr 2007 17:54:01 -0700, Barb Reinhardt
wrote:

I guess I'm confused. If you've deselected the "LOCKED" value on the
protection tab of the format cells command and then protected the sheet, it
should do exactly what you want.



"Patrick Riley" wrote:

In a protected worksheet, I want to enter a single digit in an unprotected
cell, then have the cursor move automatically to the next unprotected cell.
How can I do this?
---Patrick Riley