How do I get rid of the "clear clipboard message" when closing a workbook in VBA?

[Jimatdks]

Should be a simple question/answer.

When I close a workbook from my code, the "there's a lot of data on the clipboard, blah, blah, blah, do you want to keep it for later?" message pops up.

Is there a way to get rid of this message by clearing the clipboard or by just writing code to select "no" from the message?

Thanks.

I hope I was clear enough for you all to understand....

 

[meldoc]

Hello

Use the line below, just before you close your workbook from your code.

Application.CutCopyMode = False

See the link.

http://www.ozgrid.com/VBA/SpeedingUpVBACode.htm

 

[Jimatdks]

Thanks!