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

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

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm




"Rob" <(E-Mail Removed)> wrote in message news:13032A14-B6A4-484A-B238-(E-Mail Removed)...
>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