Tabbing to a specific cell

[eddie57]

I have a protected worksheet where I enter data and it works great. My
question is "after I hit enter how do I get the cursor to move to the
next unprotected cell after I hit enter? Currently when I enter it
moves down. I know one can have it move in a specific direction, but
there are numerous cells and some are several rows down and in
different directions.

Thanks

E

 

[ryguy7272]

Try Ctrl+G or F5.
Does that work for you?

Regards,
Ryan--

 

[Gord Dibben]

With protection you can move only east and west or north and south.

See Bob Phillips' site for more info and a couple of methods.


Gord Dibben MS Excel MVP

 

[eddie57]

I found out how to do it. It is accomplished by setting th
EnableSelection property of the sheet to 1 – xlUnlockedCells t
prevent the user selecting anything not allowed. This will only wor
when the sheet IS protected. Thanks for the reply.

Ed

PS: now that I look at it the Title was incorrect. Should of bee
"tabbing only to unprotected cells".