assigning hotkeys
 

Does anybody know how to assign a special function such as "paste special -
values" to a hotkey like ctrl-Q?

assigning hotkeys
 

Saved from a previous post:

I don't think you could change the default, but you could add the paste
special|Values button to your favorite toolbar.

You can get to via Tools|customize|Commands Tab|Edit category
Drag the "Paste Values" icon to your favorite toolbar (or create new customized
toolbar).

Other people have created macros that they assign to shortcut keys (and load
with their personal.xl* file so it's always available).

Something like:

Option Explicit
Sub MyPasteSpecialValues()
If Application.CutCopyMode = False Then
Beep
Else
ActiveCell.PasteSpecial Paste:=xlPasteValues
End If
End Sub

The assign it a nice shortcut key (Ctrl-Shift-V??).

Tools|Macro|Macros
Select the macro
Click Options
type in your shortcut key (case is important)
Ok out of that dialog
Cancel out of this one.

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

tbird79 wrote:

Does anybody know how to assign a special function such as "paste special -
values" to a hotkey like ctrl-Q?

--

Dave Peterson

assigning hotkeys
 

Would you be interested in an already built-in command icon you could place
on your toolbar?

Right click on the toolbar and choose "Customize".
<Commands tab,
Click "Edit" in the left window,
Scroll down in the right window and click on the "Paste Values" icon
(clipboard with a 12 ),
Drag to toolbar.
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"tbird79" wrote in message
...
Does anybody know how to assign a special function such as "paste special -
values" to a hotkey like ctrl-Q?