If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed.
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.
>
> 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
>
>
that event is from the MSFORMS library, not the Excel library. Therefore it
has nothing to do with Excel events.
--
Regards,
Tom Ogilvy
"dlh" <dlh.1wwx2a_1129327517.2995@excelforum-nospam.com> wrote in message
news:dlh.1wwx2a_1129327517.2995@excelforum-nospam.com...
>
> Thanks for the link, but Chip Pearson's site doesn't cover the
> BeforeDropOrPaste event.
>
> Or is there some other event that I should be capturing?
>
> -dlh
>
>
> --
> dlh
> ------------------------------------------------------------------------
> dlh's Profile: http://www.excelforum.com/member.php...o&userid=26113
> View this thread: http://www.excelforum.com/showthread...hreadid=476339
>
Linear Mode
