how to detect paste

M

mjb267

is their code available to establish if a user is pasting data rathe
than manually entering it?

ie, i want a macro to run if data is pasted in, but do nothing if dat
is entered cell by cell.

your help is appreciated
thanks
 
F

Frank Kabel

Hi
AFAIK there's no such event which is triggered by pasting. So no chance
to get this differentiation
 
V

Vic Eldridge

You can replace the built-in Paste buttons on the Edit menu and the right click
menu with your own Paste buttons that will do whatever you like.
You can also use OnKey to change what happens when you hit Ctrl+V .

Regards,
Vic Eldridge
 
Top