You could just have a macro and assign it a keyboard shortcut. I assigned z,
so if I hit CTRL+Z, it work work for me. My macros is:
Sub PasteMacro()
Selection.PasteSpecial Paste:=xlPasteValues
End Sub

--
** John C **
Please remember if your question is answered, to mark it answered :). It
helps everyone.


"D Riggins" wrote:

Is there any way to change the default bhavior of the paste operation so that
it pastes values only (without having to use Paste Special).?