View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default capture paste event into a cell

No built in event or method that will tell you this. You can certainly take
control over the application and prevent pasting unless it is under the
control of you macro.

--
Regarfds,
Tom Ogilvy

"George" wrote in message
...
right

so there is no way I can know if someone just pasted
something into my spreadsheet ?

-----Original Message-----
There is no particular event associated with pasting.

You can look at the
change event, but I am not sure it fires for a paste in

all versions of
excel. It did fire in xl2000, but the change event fires

for any edit as
well.



--
Regards,
Tom Ogilvy

wrote in message
...
I need to capture a paste event into the cell "A1"

i cannot seem to find the appropriate event for this

thank you in advance

- George



.