not moving when you hit enter

[Charlie]

It used to be in my older versions of Mac Excel, and it still is in the PC
versions, that I could choose under Tools, Options, Edit not to have the
cursor move down a cell when I hit the Enter key. If I unclicked the move
button, then Excel would stay in the same cell when I hit Enter. This is the
way I always use Excel, but now I've got a new Mac with Office 2004, and I
can't figure out how to change it so the cursor doesn't move when I hit
Enter.

It must be simple! Can anybody help me?

Thanks,
Charlie

 

[JE McGimpsey]

but now I've got a new Mac with Office 2004, and I
can't figure out how to change it so the cursor doesn't move when I hit
Enter.

It's the same way on the Mac as with WinXL:

Preferences/Edit, uncheck the "Move selection after Return" checkbox.

If you'd like to have the Enter key (e.g., on the numeric keypad on
extended keyboards) respond differently than the Return key, see

http://www.mcgimpsey.com/macoffice/excel/enterkey.html

 

[Charlie]

Thanks very much! I knew it was there somewhere. I tried the macro,
too, which worked fine, but I don't know how to save it so it will
always be there when I open Excel. Same deal. It doesn't work like
the versions I've been using. And is there a way to activate the
macro automatically when I open Excel so I don't have to do anything
to make the macro work?

Thanks again,
Charlie

 

[JE McGimpsey]

Thanks very much! I knew it was there somewhere. I tried the macro,
too, which worked fine, but I don't know how to save it so it will
always be there when I open Excel. Same deal. It doesn't work like
the versions I've been using. And is there a way to activate the
macro automatically when I open Excel so I don't have to do anything
to make the macro work?

I hint how to do it on the web page, but here's a step by step.

Put the macro in a regular code module in your Personal Macro Workbook,
or any other workbook that you store in the Microsoft Office
2004:Office:Start:Excel folder.

In the ThisWorkbook code module of that workbook, enter

Private Sub Workbook_Open()
SetUpEnterKey
End Sub

For more on where you should put macros, see

http://www.mcgimpsey.com/excel/modules.html