Unusual Perfomance

  • Thread starter Thread starter Krappo
  • Start date Start date
K

Krappo

Hi,

I know this questions sound like unusual.

I wish if anyone could help me creating a macro
for my sheets to control an active cell into one
prefered cell only.

For example in cell C3. No matter what I type
in that cell and press "Enter" the active cell still
on cell C3 and not move to other cell as usual
performed. This behaviour usually can be done
by pressing Ctrl + Enter, after entering any text
or number.

Note that the procedure only take place on
a certain sheets. And if possible I'm **not prefer
using the following sub:-

Private Sub Worksheet_Change(ByVal Target As Range)
or
Private Sub Worksheet_SelectionChange(ByVal Target As Range)

Thanks in advances for any comments or
advices. If the solutions exist, that would be
great and very much appreciate for the help.

Krappo.
 
Hi Krappo

Tools>Options>Edit
See Move selection after Enter

You can change this with code also if you want to change it for certain sheets/workbooks
Turn on your macro recorder when doing it to see the code.
 
Back
Top