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.



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

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


.

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


.