Clear Clipboard command in Excel 2007

R

Rob

I am currently using Excel 2000 and use the following command to clear the
clipboard
CommandBars("Clipboard").Controls("Clear Clipboard").Execute
I am also running Excel 2007 but when I run the macro it always stops on
this command.
Does anyone know what the equivalent command is in 2007
 
R

Ron de Bruin

Hi Rob

I think in 2007 it is only possible to call the dialog
Application.CommandBars("Office Clipboard").Visible = True

But If you copy with code you can use this after your paste line to clear the clipboard
Application.CutCopyMode = False
 

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

Macro to restore previous content of clipboard 3
Copy value of textbox to clipboard for use in another application 5
Test if clipboard empty 6
Clearing Office clipboard 2010 2
PasteSpecial method of Range class failed Error 1004 8
Macro to clear clipboard on exit 2
How to clear clipboard in ms word using VBA? 6
Clipboard macro seriously locks up (or whatever it does) myclipboard! [XL2003] 1

Top