Actually, it's pretty fast to just type this key sequence:
ALT E S V
But, if you must have a keyboard shortcut,
• Put your macro in your PERSONAL.XLS
• ALT+F8
...Select your macro
...Click the Options button
...Assign this shortcut: CTRL+J
Then, whenever you're in copy/paste mode, CTRL+J will run your macro
Is that something you can work with?