changing keyboard shortcuts

[sbitaxi]

I am trying to figure out how to change a keyboard shortcut in Excel
2002. At one time CTRL+SHIFT+V was paste special (an older version of
Office). Now I am not really sure what it does. I used to click
VIEW-TOOLBARS-CUSTOMIZE... and modify the function, but I can't seem to
in this version.

How can I change the shortcut?

 

[Dave Peterson]

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

 

[Steven Bitaxi]

I could be hallucinating, it is not impossible after all that coffee.

I like macros. Thanks for this toy. I will definitely play with it.




S