Thanks Dave. I did consider that but I really like the convenience of mouse
button actions as they don't require me to move from the active cell I am
working with.

"Dave Peterson" wrote:

How about an alternative?

Mmaybe you can just add an icon to your favorite toolbar (xl2003 and below)
or to the QAT in xl2007:

Tools|customize|Commands tab
Scroll down on the right hand side and drag "paste values" to your favorite
toolbar.



StephenD wrote:

Can I modify the right mouse click options?

Preferably I would like to do this without VBA, however . . if that is the
only way then how would I add Paste Special Formulas as a single option
(mouse click) without having to navigate into Paste Special options window?

I would like this option to be available to all of my workbooks.

Thanks in advance for any help you can provide,

Stephen

--

Dave Peterson