Can i clear Excel clipboard ? 3

[mirceapop14]

When i copy and paste from a sheet to another clipboard will do. But when i try to close workbook Windoes notify me that i have something in clipboard. Can i suppress this message or clear the clipboard ?

 

[PHV]

Have you tried to copy a blank cell before closing ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[mirceapop14]

thanks!

i resolved with Application.DisplayAlerts:=false

 

[TonyJollans]

Hi mirceapop14,

You'll need to take some action before closing - copying something which Excel considers a 'small' amount (such as a blank cell) should do it - or setting [blue]Application.CutCopyMode[/blue] to [purple]False[/purple] should (I think) clear the clipboard.

If neither of those work you'll probably need to use the Clipboard API (you should find lots of examples if you search the site).

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.