Thread: Macro to clear clipboard on exit
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
GS[_2_] GS[_2_] is offline
external usenet poster
  
Posts: 3,514
Default 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


Reply With QuoteReply With Quote