ExcelBanter - make paste values only a ctrl-key?

First, ctrl-z is the shortcut for edit|undo. I wouldn't use that combo.

Saved from a previous post:

I think you had a workbook that contained a macro that had a shortcut that used
ctrl-shift-v to do the paste special. (I don't recall it ever being in excel.)

Instead of a workbook, macro, shortcut, you could add the paste special|values
icon to your favorite toolbar.

Tools|Customize|commands tab|Edit category
scroll down the commands list until you find that icon and drag it to your
toolbar.

If you really want the shortcut key, you could have a macro like this:

Be aware that with this (and most macros), the Edit|Undo feature will be lost.

If that's ok, then this worked ok for me:

Option Explicit
Sub PasteSpecialValues()

Dim myCtrl As CommandBarControl
Set myCtrl = Application.CommandBars.FindControl(ID:=370)

On Error Resume Next
myCtrl.Execute
If Err.Number < 0 Then
Beep
Err.Clear
End If

End Sub

Tools|macro|macros|options button
give it a nice shortcut (ctrl-shift-V??)

And put it in a workbook that is always opened when excel opens -- maybe
personal.xls in your XLStart folder (or any other workbook in that same XLStart
folder).

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Ian Elliott wrote:

Thanks for any help.
I do paste values-only alot, and can I make this a control key? So when I do
ctrl-Z or some other key, it will paste value only whatever is in the
clipboard?
I looked in helpkeyboard shortcuts, but couldn't find anything about
setting keys.
Thanks

--

Dave Peterson