Help!!! I am going nuts...
I am a long time MS Excel user but relatively new to it on the Mac
(Office 2004). When trying to copy or cut and paste data, why can't I
use the enter key to paste? I am constantly having to right click and
chose paste or use the keyboard shortcut. Is there a keyboard mapping
that I need to do to get the enter key to work properly?
Well, I'm going to take a bit of an issue with "properly", since MS
initially screwed up all the keyboard mapping when they first ported XL
from Mac to Windows, but bear with me...
First, nearly all Mac applications use F4 to paste whatever is on the
clipboard, including out-of-the-box MacXL. With MacXL, of course, you
can customize nearly every command's keyboard shortcut using
Tools/Customize/Customize Keyboard...
WinXL's Enter key acts to paste data only if the WinOffice clipboard
contains data copied or cut from XL. Otherwise it acts as an Enter key.
MacXL uses the Mac system clipboard to copy and paste. That clipboard is
persistent, compared to the WinOffice clipboard, and (AFAIK) doesn't
indicate the source application, so using exactly the same mapping would
cause the Enter key to paste data from ANY application, which is very
likely NOT what you want.
However, you can approximate the WinXL behavior if you wish:
In your Personal Macro Workbook (or, my preference, in an add-in), enter
this into the ThisWorkbook code module (CTRL-click the workbook title
bar and choose View Code):
Private Sub Workbook_Open()
Application.OnKey "{Enter}", "EnterPaste"
End Sub
Then create a new module in that workbook/add-in and paste
Public Sub EnterPaste()
If TypeOf Selection Is Range Then _
If Application.CutCopyMode Then _
Selection.Parent.Paste
End Sub
Note that this will only affect the Enter key, not the Return key.
