Macro to clear Clipboard

[gj]

Can't find a way to clear the clipboard using a macro

Thanks
GJ

 

[Dave Peterson]

Maybe...

application.cutcopymode = false

??

Can't find a way to clear the clipboard using a macro

Thanks
GJ

 

[Guest]

Hi,

This does not work for me. Is there something else I should be looking for?
I'm in Excel 2003.

Thanks,

 

[Dave Peterson]

Chip Pearson has some nice notes at:
http://www.cpearson.com/excel/clipboar.htm
for working with the windows clipboard.

But I don't recall ever seeing application.cutcopymode=false fail in a windows
environment.

 

[NickHK]

How does it fail ?

NickHK

Hi,

This does not work for me. Is there something else I should be looking for?
I'm in Excel 2003.

Thanks,

 

[Guest]

Nothing happens. I have this - Application.DisplayClipboardWindow = True
to show the clipboard. I've tried Application.CutCopyMode = False before and
after displaying the clipboard and in either case it doesn't clear the
clipboard.

Thanks,