Code to get an alert window to answer no

I have a very large macro that copies information from about 20 different excel databases and pastes them to a single database. The problem I am having is with the display alerts turned off it is saving the copied information to the clip board automaticly, creating issues. Is there a specific code to get have VBA tell the alert window to answer "no"?

Hello mdnghtsnpr,

Setting Application.DisplayAlerts = False automatically activates the default button of the dialog box. The question in my mind is why are you using the clipboard? As a general rule, it is not necessary to use the clipboard to copy information from application to application, unless you want to preserve formatting.

If you don't need the formats and only the raw data then your macro needs to modified not to use the clipboard. Direct information transfer will eliminate the clipboard messages and the need to answer them either manually or automatically. You would need to post code before any changes could be suggested.