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