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

Test if clipboard empty 6
Macro to restore previous content of clipboard 3
Clearing Office clipboard 2010 2
Office Clipboard: Clear all with VBA-macro? 0
Clear Office Clipboard from VBA? 22
Clear Excel Clipboard with VBA 2
Copy value of textbox to clipboard for use in another application 5
How to clear clipboard in ms word using VBA? 6

Top