Solved: how to change direction of move after Enter in one sheet

[danovkos]

Hi all,
pls. is here any possibility how can i change my default behavior (movoment) of cursor after pressing enter?

What i need is change this only for one sheet in one WB and change it from "move to down" to "move to right".

And for all other WB and sheets it will be default "move to down"

How can i do that pls?

what i found with google was only change it for whole wb :(

thx for help

[p45cal]

in the code module for the sheet concerned:Private Sub Worksheet_Activate()
Application.MoveAfterReturnDirection = xlToRight
End Sub
Private Sub Worksheet_Deactivate()
Application.MoveAfterReturnDirection = xlDown
End Sub
This is not very friendly if the file will be used on other's machines as it leaves this setting as xlDown which may not be their preference.

[danovkos]

yes it works great...
thank you very much

[slamet Harto]

How about if I want cursor move to down to the third column
example. current cursor position is in A1, after pressing enter will move to A3.

Thanks!

[hardlife]

Private Sub Worksheet_Activate()
'Application.MoveAfterReturnDirection = xlToRight
End Sub

Private Sub Worksheet_Deactivate()
Application.MoveAfterReturnDirection = xlDown
End Sub

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
'Cells(ActiveCell.Row, 3).Activate
Cells(3, ActiveCell.Column).Activate
End Sub


Hi Harto, try this,

HTH :hi:

Pavel