Hello, Excel Experts:

I need help to auto close prompts & Dialog boxes for saving change. My
program opens one
workbook, sort the data on one sheet and then copy the selection, then
open another workbook to paste the data on one of the sheet. My
problem is that the excel won't let me close the first workbook without
showing two dialogue boxes- one is asking is the user if he wants to
save the change before closing the book, another dialog box is asking
the user if he wants to save or clear the data in the clipboard. For
both message, the user should click the "no" button. I want to write
some code to close these dialog boxes automatically or prevent them to
appear.

I have tried to run some Micros to see if it will show me the code, but
no success. Does anyone know how to do that? I really appreciate any
help or suggestions. Thank you very much.

KHW