Thread: automate clear clipboard
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
  
Posts: 11,123
Default automate clear clipboard
Hi YZXIA

With VBA you use this after your paste code line

Application.CutCopyMode = False



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"YZXIA" wrote in message oups.com...
How do I automate clear clipboard with VBA? automate Edit - office
clipboard -clear all

I tried to record the VBA code but no code was recorded.

Reply With QuoteReply With Quote