how to detect paste
 

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

--
Message posted from http://www.ExcelForum.com

how to detect paste
 

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

--
Regards
Frank Kabel
Frankfurt, Germany

"mjb267 " schrieb im
Newsbeitrag ...
is their code available to establish if a user is pasting data rather
than manually entering it?

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

your help is appreciated
thanks!


---
Message posted from http://www.ExcelForum.com/

how to detect paste
 

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



mjb267 wrote in message ...
is their code available to establish if a user is pasting data rather
than manually entering it?

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

your help is appreciated
thanks!


---
Message posted from http://www.ExcelForum.com/

how to detect paste
 

I found another way around it, but that is an awesome idea! thanks fo
your help

--
Message posted from http://www.ExcelForum.com