ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How to clear the clipboard contents in VBA (https://www.excelbanter.com/excel-programming/355191-how-clear-clipboard-contents-vba.html)

Wilbur[_6_]

How to clear the clipboard contents in VBA
 

How to clear the clipboard contents in VBA using code. If I do a
WORKSHEET(anyname).Copy it puts the contents in the clipboard and then
paste is fine. Now how would I clear out clipboard?

Thanks


--
Wilbur
------------------------------------------------------------------------
Wilbur's Profile: http://www.excelforum.com/member.php...o&userid=31826
View this thread: http://www.excelforum.com/showthread...hreadid=519304


Don Guillett

How to clear the clipboard contents in VBA
 
try
application.cutcopymode=false

--
Don Guillett
SalesAid Software

"Wilbur" wrote in
message ...

How to clear the clipboard contents in VBA using code. If I do a
WORKSHEET(anyname).Copy it puts the contents in the clipboard and then
paste is fine. Now how would I clear out clipboard?

Thanks


--
Wilbur
------------------------------------------------------------------------
Wilbur's Profile:
http://www.excelforum.com/member.php...o&userid=31826
View this thread: http://www.excelforum.com/showthread...hreadid=519304





All times are GMT +1. The time now is 04:06 AM.

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