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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Capture the Source Address of copied data 1
Trapping value before and after change 3
Capture autosave/autorecover event 2
How to Capture right click Delete/Insert on Excel 8
how to capture the event changing the name of a sheet 1
Avoid protected cell warning on BeforeDoubleClick WS event 2
Capture Worksheet Change Value 1
Capturing cell address and contents 2

Back
Top