Changing Default Paste behavior

D

D Riggins

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).?
 
J

John C

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
 
Top