ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Creating a shortcut (https://www.excelbanter.com/excel-programming/276668-re-creating-shortcut.html)

Jean-Paul Viel

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






All times are GMT +1. The time now is 12:27 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com