Clearing the clipboard

**Kevlar** · 11-22-2006, 04:09 PM

Is there a way to clear the contents of the clipboard programatically?

**VBA Noob** · 11-22-2006, 04:15 PM

Hi,

Does this code work

Please Login or Register  to view this content.

VBA Noov

**dominicb** · 11-22-2006, 05:50 PM

Hi VBA Noob

The CutCopyMode=False just removes the "marching ants". As the clipboard is a Windows object you need API's to clear it effectively.

Please Login or Register  to view this content.

Calling the macro ClearClipboard should do just that.

HTH

DominicB

**VBA Noob** · 11-22-2006, 06:02 PM

Thanks DominicB for the correction

VBA Noob

**Kevlar** · 11-22-2006, 06:20 PM

Thank you as well Dominicb