[Ali.Abughrabieh[_2_]]

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

"Ali.Abughrabieh" wrote:

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

[joel]

Use a worksheet change event

Sub worksheet_change(ByVal target As Range)

target.Select

End Sub


"Ali.Abughrabieh" wrote:

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

[Gord Dibben]

ToolsOptionsEdit. Uncheck "move selection after enter"


Gord Dibben MS Excel MVP

On Sun, 8 Jun 2008 02:19:00 -0700, Ali.Abughrabieh
wrote:

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