I have a macro that copies the contents of spreadsheet "A" into spreadsheet "B".  The contents are then summed in spreadsheet "B".  I close spreadsheet "A" and there's a message asking if I want to leave the massive data on the clipboard.  I have to move the answer from yes to no and press enter.

I haven't found a way to have the macro answer NO.