capture paste event into a cell

G

Guest

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
 
T

Tom Ogilvy

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.
 
G

George

right

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

Tom Ogilvy

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.
 
Top