View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Move selection after Enter

If you hide row 2, then A3 would be selected.

--
Regards,
Tom Ogilvy


Kevin wrote in message
...
It is possible to prevent certain cells from being
activated? That is, if the Edit tab in the Tools/Options
menu shows "Move selection after Enter" to be checked
and "Direction" to be set to "Down"...cell A2 becomes the
active call after I enter a number in cell A1. Is there a
way of modifying cell A2 to force cell A3 to become the
active cell after I enter a number in cell A1?

Thanks.


Kevin