Not sure about XP/2003, but in 2000 the clipboard window is a CommandBar, so
you can use the CommandBar object to at least show/hide and activate the
clipboard window controls; e.g.
CommandBars("Clipboard").Visible = True
CommandBars("Clipboard").Controls(4).Execute ' Controls(4) is the Clear
Clipboard button
CommandBars("Clipboard").Visible = False

It does not appear you can set the options from the CommandBar object, so
you would need to programmatically access the menu items; this could probably
be done through the Windows API (CheckMenuItem); for details see
http://msdn.microsoft.com/library/de...rces/menus.asp

"quartz" wrote:

Is it possible to clear the contents of the Office clipboard window that pops
up in Windows XP and Excel 2003 using VBA? I have tried several methods that
fail.

Also, is it possible to programmatically set its options (e.g. "Show office
clipboard icon in taskbar", "Collect without showing Office Clipboard" etc.)?

Could someone please post example code/functions? Thanks much in advance.