ExcelBanter - freez the enter

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - freez the enter (https://www.excelbanter.com/excel-discussion-misc-queries/190437-freez-enter.html)

Ali.Abughrabieh[_2_]

freez the enter

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

Mike H

freez the enter

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

freez the enter

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

freez the enter

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 :)

All times are GMT +1. The time now is 10:10 AM.