clear the clipboard?

  • Thread starter Thread starter scottnshelly
  • Start date Start date
S

scottnshelly

Hey,
i need to have a code that will empty my clipboard. any suggestions?
i got as far as application.clipboardformats....
Thank
 
From Chip Pearson:

http://www.cpearson.com/excel/clipboar.htm

Public Sub ClearClipboard()
Dim MyDataObj As New DataObject
MyDataObj.SetText ""
MyDataObj.PutInClipboard
End Sub

If you just want to clear the clipboard of stuff that you've put there using
Excel's Copy function, you can simply use:

Application.CutCopyMode = False
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Clearing Office clipboard 2010 2
Test if clipboard empty 6
Check if clipboard is empty before pasting 1
Macro to restore previous content of clipboard 3
Macro to clear clipboard on exit 2
Clear Clipboard command in Excel 2007 1
How to clear clipboard in ms word using VBA? 6
Clear Office Clipboard from VBA? 22

Back
Top