stay in same cell after enter

[JWARD]

if im in a1 and hit the enter key, automatically goes to cell b1. is there a setting so that it will stay in cell a1 after ther enter key is hit?

 

[gaynard_nelson]

if im in a1 and hit the enter key, automatically goes to cell b1. is there a setting so that it will stay in cell a1 after ther enter key is hit?

Go to Tools, Options, Edit tab and remove the check mark under Settings, Move selection after Enter.

 

[daniels012]

Go to tools...Options...Edit (tab)... then where is says move selection after enter just uncheck!!

Hope this helps,
michael

 

[bluefeather8989]

Sub DisableKeys()
    Application.OnKey "{ENTER}", ""
End Sub

Sub EnableKeys()
    Application.OnKey "{ENTER}"
End Sub