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
 
Ad

Advertisements

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
 
Ad

Advertisements

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

Top