Shortcut key for Paste Values
Posted by Alan on January 01, 2002 1:28 PM
Is there an easy way to assign a shortcut key (such as Alt+Ctrl+V) to the Paste Values command? I've already added a button to my toolbar.
Posted by Joel Horowitz on January 01, 2002 1:32 PM
Well, what I usually do is ALT-e-s-v followed by ENTER. It looks a little primitive, but once you're used it works fine.
Posted by Alan Levin on January 01, 2002 1:40 PM
Posted by Alan Levin on January 01, 2002 1:42 PM
Thanks-- Of course that works, since it navigates the menus using the keyboard. Is there a way to assign an actual keyboard shortcut, though?
Posted by Jacob on January 01, 2002 1:52 PM
Hi
Make a macro and put it in your personal.xls workbook.
Private sub PasteIt()
Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _
False, Transpose:=False
End Sub
Then assign a hot key to trigger it.
Jacob
Posted by Alan Levin on January 01, 2002 2:37 PM
Jacob-- You're absolutely right-- thank you.
Alan
Posted by Joel Horowitz on January 02, 2002 7:25 AM
Danger of using a macro
The danger of that is that there is no possibility for undoing this action, which can be very annoying when you paste values where you copied them (= you may look formulas). Am I wrong?
Joel
