ExcelBanter - automate clear clipboard

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - automate clear clipboard (https://www.excelbanter.com/excel-programming/382504-automate-clear-clipboard.html)

YZXIA

automate clear clipboard

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.

Ron de Bruin

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.

Gord Dibben

automate clear clipboard

Application.CutCopyMode = False

Gord Dibben MS Excel MVP

On 2 Feb 2007 12:38:41 -0800, "YZXIA" wrote:

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.

All times are GMT +1. The time now is 09:29 PM.