View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JLatham JLatham is offline
external usenet poster
 
Posts: 3,365
Default have excel go to defined cells when pressing enter

You could use Format | Cells | [Protection] and Lock all cells then go back
and choose the ones you want to get to in this manner and then Unlock them.
Protect the worksheet (Tools | Protection | Protect Sheet) with the option to
permit selecting locked cells turned off. As they use [Tab] or [Enter] they
will move from one unlocked cell to the next without stopping in between.

"rrg" wrote:

How can I have excel go to defined cells when pressing ENTER after entering
info in a cell
(from cell Aa1 input info press Enter and go to H16 to input info in that
cell press ENTER go to A45 and so on)