View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JON JON JON JON is offline
external usenet poster
 
Posts: 62
Default Skip to next input cell on protected worksheet

if your using xl 2002 you can uncheck select lock cells in the protect
sheet option.


"Fred" wrote in message
oups.com...
Is there a way of skipping to the next input cell, on a protected
worksheet, when the enter/return key is pressed ?

I have a protected worksheet with a number of input cells. Because of
the layout there are rows in between the input cells, so when
enter/return is pressed the cell immediately below the current one is
selected, instead, I would like to move to the next input cell at this
point.

Thanks and regards
Fred