Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating a shortcut
Hi,
1.. Create a macro like that: Sub MyPasteSpecial() Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False End Sub 2.. Go to Tools Macro Macros. 3.. In Options assign a shortcut. -- JP http://www.solutionsvba.com "jeff" wrote in message ... I would like to know if it is possible to create a shortcut for the Paste special option. Example. CUT= ctrl+X Copy= ctrl+c Paste= ctrl+V I would like to know how to create a shortcut for the Paste special. Does any one know how to do this?? Any info would help. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating a Shortcut Key | Excel Discussion (Misc queries) | |||
Creating a Word filename shortcut in Excel | Excel Discussion (Misc queries) | |||
Creating Shortcut | Excel Discussion (Misc queries) | |||
Creating a Combined Date/Time Shortcut | Excel Discussion (Misc queries) | |||
Creating shortcut keys | Excel Discussion (Misc queries) |