Tabbing to a specific cell

E

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
 
G

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
 
E

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Enter data, move automatically to next unprotected cell 10
Tabbing on a Protected worksheet 3
How do i change the color of a cell when tabbing? 2
Tabbing Question 7
Excel 2003- Tabbing to a specific location in a cell 6
Hitting Enter to Move Cursor to the Next Entry Cell 3
Cursor Movement? 10
How do I require data entry in a cell before moving to the next ce 3

Top