Is it possible to change the behavior of "paste" control in Excel?

[Guest]

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

 

[Corey]

You could try using 'Macro Recorder' in conjunction with 'PASTE SPECIAL',
to give you some idea of the possibilties available.

Corey....