Disable msg box when closing a workbook.

[dfarland]

I am trying to close a workbook from a macro. I get the message that there is data on the clipboard and do you want to keep it.

I know there is a way of stopping that message, but I can't remember what it is.

thanks

 

[TonyJollans]

Hi dfarland,

Try ..

[blue][tt] Application.DisplayAlerts = False[/tt][/blue]

.. or, possibly, ..

[blue][tt] Application.CutCopyMode = False[/tt][/blue]



Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.
Excel VBA Training and more Help at [url=http://www.vbaexpress.