Just an idea but I worked round that one by saving data in an array (i.e. using
myArray = myRange.value etc) rather than using copy and paste.
The only problem is that cell formats wont be saved.

Regards
Noel


"Randy" wrote:

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.