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

Top