capture paste event into a cell

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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.
 
right

so there is no way I can know if someone just pasted
something into my spreadsheet ?
 
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.
 
Back
Top