Try using
Application.CutCopyMode = False
before closing the workbook

Matt wrote:
What if you want to not have the message:

"There is a large amount of information on the Clipboard. Would you like
it...blah blah"

come up?

Thanks again

"Andrew Taylor" wrote:

For saving and closing a workbook the best way is to use the
SaveChanges parameter of the Workbook.Close method:

ActiveWorkbook.Close SaveChanges:=True

You can also prevent certain prompts by using
Application.DisplayAlerts, e.g.

Application.DisplayAlerts = False
ActiveWorkbook.Sheets(1).Delete ' prevents "are you sure?" prompt
ActiveWorkbook.SaveAs "c:\junk.xls" ' prevents prompt if file
exists
Application.DisplayAlerts = True ' reset prompts

hth
Andrew


Matt wrote:
Is there a way to automatically answer questions that pop up as you are
manipulating files? For example, after performing specific functions to a
file, I have it close, but then the questoin comes up "Would you like to save
the changes you have made to file ABC?" - and the answer will always be
yes...so is there a way to code for that? Thanks in advance!