Is there a way to capture the event of Pasting (or Dragging and
Dropping) something into a worksheet? I'd like to intercept such
events and make sure that only values are pasted, so the user doesn't
inadvertently muck up the formatting of the worksheet.

Or would it be better to write a macro to restore the original
formatting after the fact? (That would be long and tedius.)

I've found a BeforeDropOrPaste event, but I can't find any examples of
how to use it and it seems rather nontrivial.

-dlh


--
dlh
------------------------------------------------------------------------
dlh's Profile: http://www.excelforum.com/member.php...o&userid=26113
View this thread: http://www.excelforum.com/showthread...hreadid=476339