ExcelBanter - How to set Paste:=xlPasteValues for all paste operations?

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

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

- - How to set Paste:=xlPasteValues for all paste operations? (https://www.excelbanter.com/excel-programming/372283-how-set-paste-%3Dxlpastevalues-all-paste-operations.html)

[email protected]

How to set Paste:=xlPasteValues for all paste operations?

Hello,

Maybe you know if there is a property or a method that enables to block
"paste as Values" option. Is there any way to use always "paste" form
the menu as "paste as Values"?

Thanx for your advice.
Pawel.

Ron de Bruin

How to set Paste:=xlPasteValues for all paste operations?

Hi Pawel

You can disable it if you want
http://www.rondebruin.nl/menuid.htm

--
Regards Ron de Bruin
http://www.rondebruin.nl

wrote in message ups.com...
Hello,

Maybe you know if there is a property or a method that enables to block
"paste as Values" option. Is there any way to use always "paste" form
the menu as "paste as Values"?

Thanx for your advice.
Pawel.

NickHK

How to set Paste:=xlPasteValues for all paste operations?

Pawel,
You want to "block "paste as Values" option" OR "always "paste" form the
menu as "paste as Values" " ?

NickHK

wrote in message
ups.com...
Hello,

Maybe you know if there is a property or a method that enables to block
"paste as Values" option. Is there any way to use always "paste" form
the menu as "paste as Values"?

Thanx for your advice.
Pawel.

All times are GMT +1. The time now is 05:27 AM.