View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jean-Paul Viel Jean-Paul Viel is offline
external usenet poster
 
Posts: 39
Default 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