Ckear Clipboard

R

Ronbo

How do I Clear the Contents on the clipboard. I have
tried using Application.CutCopyMode = False, but it does
not clear the clipboard.

Any help would be appreciated.
 
C

Charles

On you worksheet click view toolbar and select clipboard. There is a
Icon on it that will delete the clipboard contents.

HTH

Charle
 
T

Tom Ogilvy

that will work if you copied cells to the clipboard.

You can use the API for others.

Previously posted by Chip Pearson:

Public Declare Function OpenClipboard Lib _
"user32" (ByVal hwnd As Long) As Long
Public Declare Function CloseClipboard Lib _
"user32" () As Long
Public Declare Function EmptyClipboard Lib _
"user32" () As Long

Sub ClearClipboard()
OpenClipboard 0&
EmptyClipboard
CloseClipboard
End Sub
 
Top