Application.CutCopyMode = False

before you execute the command that causes the prompt will clear the
clipboard and prevent it.

or

Application.DisplayAlerts = False
' code that causes the prompt
Application.DisplayAlerts = True

--
Regards,
Tom Ogilvy


"hmm" wrote:

In closing a large file, Excel asks if you want to retain its contents in the
clipboard. This confirmation request even occurs when a macro closes the
file. What code do I use to disable this confirmation message (and proceed
to just close the file)?