Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Selection won't move when I press enter...do you know why? | Excel Discussion (Misc queries) | |||
how do I move selection after enter direction | Excel Discussion (Misc queries) | |||
Easily change Move selection after Enter option | Excel Discussion (Misc queries) | |||
Move Selection after Enter | Excel Discussion (Misc queries) | |||
Tools - Option - "move selection after enter" | Excel Worksheet Functions |