ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Clipboard (https://www.excelbanter.com/excel-programming/289915-clipboard.html)

MD

Clipboard
 
his there a code to clear-up all that is stored in the office clipboard and
windows clipboard other than application.cutcopymode = false

thanks
Michel



david mcritchie

Clipboard
 
Please don't repost the same question to another thread it makes
things difficult for everyone and wastes time. See J.E.'s answer
in http://google.com/groups?threadm=jem....microsoft.com

Not knowing anything about Macs, I would assume his
solution provided an answer to you and explained to the rest of
us why you don't want the obvious answer, and JE supplied a
reason why you might want something different.

Thanks for posting the original question with the detail of
not wanting the obvious answer -- that certainly saved one
round of back and forth conversation, but the reason would
have been good to include -- we can only guess if JE guessed right.

Please continue in your original thread.



Tom Ogilvy

Clipboard
 
Public Declare Function OpenClipboard Lib "user32" ( _
ByVal hwnd AsLong) 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

Put declarations in a General module.

--
Regards,
Tom Ogilvy


MD wrote in message
...
his there a code to clear-up all that is stored in the office clipboard

and
windows clipboard other than application.cutcopymode = false

thanks
Michel





Tom Ogilvy

Clipboard
 
Public Declare Function OpenClipboard Lib "user32" ( _
ByVal hwnd AsLong) 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

Put declarations in a General module.

--
Regards,
Tom Ogilvy

"MD" wrote in message
...
his there a code to clear-up all that is stored in the office clipboard

and
windows clipboard other than application.cutcopymode = false

thanks
Michel






All times are GMT +1. The time now is 02:00 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com