Application.OnKey during Copy mode

C

Carim

Hi,

I am trying to assign a macro to the Enter key with
Application.OnKey "{Enter}","Macro1"
which works fine ... but I need to restrict its scope down to the Copy
mode ...
It is the "Enter" which does the pasting that I have to isolate ...
So far my attempts with Application.CutCopyMode have not been
successful ...
Is there a way ?

TIA
Carim
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional application.onkey in realtime? 2
Autorun macro does not autorun... 5
Mis-performing MP4 files in Mac PPT 1
Capture paste from Office Clipboard 1
Application.OnKey syntax for + and - keys 0
How to map a shortcut key to a routine in COM AddIn for Excel 2007 21
Outlook Loses Login/Password on Exchange After CCleaner Runs 0
SUMPRODUCT anomoly 2

Top