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