Ram,
Not sure if it is workable for you, but if you share the workbook, can you
monitor the change history ?
Won't catch a copy though.

NickHk

"RNG" wrote in message
...
Thanks to both for the responses!

- Ram


"DM Unseen" wrote:

you can use the Application.Worksheet_Change event to capture pasting
cells, but a more complete solution is to use the Application.Onkey
function and rewrite cut/copy/paste key shortcuts. Since in Excel(2000
and higer) you can also capture events from commandbuttons you could
aslo hook your code to the cut/copy/paste buttons so you also cover
that route. Nasty, but should be workable.

remember that excel cannot do anything while in cell editing mode, so
cutting/copying/pasting *inside* a cell cannot be detected from an app
running inside the Excel thread. Any code that needs to act on cell
text(I'm not sure you need it) needs to be out of process using
subclassing and window hooks(brrr). You did not write which clipboard
formats you wanted to act upon, but I suspect Ranges is your primary
concern.

DM Unseen