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
 
Back
Top