| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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/ |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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/ |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| need to detect syntax in value | Excel Discussion (Misc queries) | |||
| How to detect #N/A and return 0? | Excel Discussion (Misc queries) | |||
| How to detect changes in a column? | Excel Discussion (Misc queries) | |||
| Detect any Volatile UDF | Excel Programming | |||
| How to detect a col/row deletion? | Excel Programming | |||
Linear Mode
