Hide the DisplayPasteOptions

[Richard]

Hi all,

I am using the following code to ensure that a cell's format does not differ from the Color and
NumberFormat when there is a change (like a paste or copy). It works fine, but the #!@!?&%$ Paste
Options dialog (or whatever that cute pop-up is called) still shows up...how do I stop it?

With Application
.EnableEvents = False
.DisplayPasteOptions = False
With Target
.Interior.Color = ActiveCell.Offset(-1, 0).Interior.Color
.NumberFormat = "$#,##0.00_);[Red]($#,##0.00)"
End With
.DisplayPasteOptions = True
.EnableEvents = True
End With


Thanks,

Richard

 

[Nigel]

Where is code installed, and what event triggers it?

Cheers
Nigel