Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
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




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Creating a Shortcut Key vlhogg5 Excel Discussion (Misc queries) 1 February 18th 09 11:45 PM
Creating a Word filename shortcut in Excel Creating a Word shortcut in Excel Excel Discussion (Misc queries) 2 November 25th 07 10:33 PM
Creating Shortcut eylul Excel Discussion (Misc queries) 3 June 11th 05 01:24 PM
Creating a Combined Date/Time Shortcut Michael Link Excel Discussion (Misc queries) 7 February 15th 05 12:42 AM
Creating shortcut keys Magnus Ramfelt via OfficeKB.com Excel Discussion (Misc queries) 1 January 21st 05 01:06 PM


All times are GMT +1. The time now is 09:20 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"