When using macros to retreive data from other spreadsheets (along with
copy and paste) and when closing the spreadsheet a dialog box appears
asking if you want to save the the information to the clipboard which
stops the macro until you answer the dialog box. Is there a way to
close the dialog box and not save the information on the clipboard in
the macro instead of having to answer.