I want to make the movement of key

[bnageshrao]

I want to make the movement of key horizontal(moving to the right) when using the "Enter" Key. I used the options and settings and it works for fine. But this is user specific and not program specific. Can we write a code for the movement to be horizontal no matter what is the setting in Options submenu? Also when the cursor is in the last cell of the row is it possible to make it to go to the first cell of the next row when you press 'Enter' Key. If any body can help me on this I will be really thankful. Thanks in advance.

 

[LoNeRaVeR]

bnageshrao:

Put the following code in any workbook and it will change the Enter direction to move to the right instead of down. Put this code in your Personal.xls file to make it happen whenever Excel opens.
[tt]
Sub Autpen()
Application.MoveAfterReturnDirection = xlToRight
End Sub
[/tt]
Regards,

LoNeRaVeR

 

[bnageshrao]

The problem is I want to finish this spread sheet and send it to different sites. If I can write a code right in my application to achieve the movement of the cursor to the right then it will be great then users dont have to do anything with their machine by putting those code in personal.xls. So anyother way?

 

[LoNeRaVeR]

bnageshrao:

It will still work, just put this line at the beginning of your code:
[tt]
Application.MoveAfterReturnDirection = xlToRight
[/tt]
Regards,

LoNeRaVeR