Changing Default Paste behavior

  • Thread starter Thread starter D Riggins
  • Start date Start date
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).?
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top