Cursor to go to Specific cell

  • Thread starter Thread starter Mat
  • Start date Start date
M

Mat

Hi,

I am preparing a Sales form and i need the cursor to to the next unblocked
cell when the user hits "Enter".

I can use this function on "Tab" key but when the user hits the "Enter" key
the cursor goes to the block cell.

Thanks & Regards
 
Try protecting the full sheet. Then go back and select the cells that you
want user to have access to and protect them. After that, protect worksheet,
and select to allow user to only select unprotected cells. This should do it.
 
Try protecting the full sheet. Then go back and select the cells that you
want user to have access to and protect them. After that, protect worksheet,
and select to allow user to only select unprotected cells. This should do it.
 
Scott

I think you meant.............LOCK all cells then go back and select the
cells that you want user to have access to and UNLOCK them.


Gord Dibben MS Excel MVP
 
Scott

I think you meant.............LOCK all cells then go back and select the
cells that you want user to have access to and UNLOCK them.


Gord Dibben MS Excel MVP
 

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

Moving Cursor after Cell Entry 1
Using Tab key to jump to specific cell 2
Cursor Movement 2
set macro to a cell 4
Cursor 1
How do i make the arrow keys tab to the next cell? 1
in excel when i hit return, the cursor does not drop down 1 cell 2
Excel VBA to move cursor from 1 cell to another, once original cell is filled with data. 3

Back
Top