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

Move selection after Enter
 

In the sheet code..

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
If Target.Address = "$A$1" Then Range("$A$3").Select
End Sub


Tom Ogilvy wrote in message
...
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

Move selection after Enter
 

Thanks Stuart.

This works just fine.


-Kevin

----- Stuart wrote: -----

In the sheet code..

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
If Target.Address = "$A$1" Then Range("$A$3").Select
End Sub


Tom Ogilvy wrote in message
...
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