Remove annoying message "Do you want to save data on clipboard"

[Wamhoi]

So I created a VBA that closes an activeworkbook but then I get this message that says "There is a large amount of information on the clipboard. Do you want to be able to paste this information into another program later?"

I want to always say no.

Does anyone know how I can do this?

 

[Gerald Higgins]

I haven't tested this, but I think

Application.DisplayAlerts=False

will do this.

You might want to set it back to True afterwards, if there are other alerts that you do want to see.

 

[njimack]

Have you tried clearing the clipboard after copying your data?
Application.CutCopyMode = False

 

[Wamhoi]

Perfect! Application.cutcopymode = false did the trick. I didn't test the other but I'm sure it does the same.

Thanks!

 

[Gerald Higgins]

They certainly don't do the same thing, although they would probably both work in your situation.

 

[Wamhoi]

Oh I apologize, I'm still fairly new to VBA.

 

[Gerald Higgins]

No need to apologise I'm pretty new to VBA myself !