freez the enter

[Ali.Abughrabieh]

how i can freez the enter in the same cell when i press it

 

[Mike H]

Hi,

Try

Tools|Options|Edit
un-check "Move selection after enter"

Mike

 

[Joel]

Use a worksheet change event

Sub worksheet_change(ByVal target As Range)

target.Select

End Sub

 

[Gord Dibben]

Tools>Options>Edit. Uncheck "move selection after enter"


Gord Dibben MS Excel MVP