Ckear Clipboard

  • Thread starter Thread starter Ronbo
  • Start date Start date
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.
 
On you worksheet click view toolbar and select clipboard. There is a
Icon on it that will delete the clipboard contents.

HTH

Charle
 
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
 
Back
Top