Hide the DisplayPasteOptions
 

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

Hide the DisplayPasteOptions
 

Where is code installed, and what event triggers it?

Cheers
Nigel

"Richard" wrote in message
news:o7kic.11092$cF6.478019@attbi_s04...
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