ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Macro to clear clipboard on exit (https://www.excelbanter.com/excel-programming/444392-macro-clear-clipboard-exit.html)

Fan924

Macro to clear clipboard on exit
 
In a macro, I do some copying and pasting and would like to exit the
Macro with an empty clipboard. Anyone?

GS[_2_]

Macro to clear clipboard on exit
 
Fan924 presented the following explanation :
In a macro, I do some copying and pasting and would like to exit the
Macro with an empty clipboard. Anyone?


Try...

Application.CutCopyMode = False 'clear the clipboard

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc



Fan924

Macro to clear clipboard on exit
 
sweet......


All times are GMT +1. The time now is 10:35 PM.

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