Disable clipboard confirmation

[hmm]

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)?

 

[Tom Ogilvy]

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

 

[hmm]

Thanks Tom.

FYI, clearing the clipboard is faster execution than disabling display
alerts. My next step is to disable screen updating.