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