stop prompt for delete data from clipboard

[obiron]

using Excel 2003 over Citrix

I have adopted an application which opens a worksheet and copies the data to another worksheet then closes the original worksheet. I get the message "you have copied a large amount of data to the clipboard...."
and the user has to select Yes or no - I want to get rid of the prompt and just discard the clipboard data.

If I set application.displayAlerts = False then the app just hangs.

Is there another way to explicitly clear the clipboard?

Obiron

 

[RoryA]

Application.CutCopyMode = False

should do it.

 

[niceguy_jay]

how about

Application.CutCopyMode = False

</pre>

 

[obiron]

Thanks Jay,
That did the trick..

Obiron