| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is it possible to change the behavior of "paste" control in Excel?
Hi all.
Does anyone know if it is possible to change the behavior of the "paste" control in the Edit menu or the right-click context menu? In some workbooks I would like to make the paste control do "paste formula" only without changing the format or color of the cells. I have already found a way to change the paste behvior for Ctrl-V and Shift-Insert by executing the following Application.Onkey statements. Application.OnKey "^v", "PasteValueOnly" Application.OnKey "+{INSERT}", "PasteValueOnly" shortcut key And I would like to do the same for the "Paste" control in the right-click context menu. If anyone know how to do this, please let me know. Thank you very much. Jason |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Is it possible to change the behavior of "paste" control in Excel?
You could try using 'Macro Recorder' in conjunction with 'PASTE SPECIAL',
to give you some idea of the possibilties available. Corey.... wrote in message ... Hi all. Does anyone know if it is possible to change the behavior of the "paste" control in the Edit menu or the right-click context menu? In some workbooks I would like to make the paste control do "paste formula" only without changing the format or color of the cells. I have already found a way to change the paste behvior for Ctrl-V and Shift-Insert by executing the following Application.Onkey statements. Application.OnKey "^v", "PasteValueOnly" Application.OnKey "+{INSERT}", "PasteValueOnly" shortcut key And I would like to do the same for the "Paste" control in the right-click context menu. If anyone know how to do this, please let me know. Thank you very much. Jason |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I change the column heading in Excel to display "A" "B" "C | New Users to Excel | |||
| change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
| What is Error "Method "Paste" of object "_Worksheet" failed? | Excel Programming | |||
| Complex if test program possible? If "value" "value", paste "value" in another cell? | Excel Discussion (Misc queries) | |||
| excel should "paste special" a "conditional formatting" | Excel Programming | |||
Linear Mode
