Code to get an 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.