View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
FSt1 FSt1 is offline
external usenet poster
 
Posts: 3,942
Default how do I assign a CTRL + shortcut key to a menu item (paste speci.

hi
you can record a macro that duplicate the editpaste command and assign a
shortcut key to the macro.
to make sure you don't duplicate a shortcut, see these sites...
2003 and back
http://www.cpearson.com/excel/KeyboardShortcuts.htm
2007-some change-some new
http://www.keyxl.com/aaa33ef/136/Mic...-shortcuts.htm

regards
FSt1

"PaulGB" wrote:

Hi I want to assign a CTRL + (any key) to the Edit - Paste Special command.
Any suggestions.. and how do I make sure that the combination hasn't already
been assigned?

note : if I use &S shortcut I have to open the edit menu first, so it takes
two key presses..

Thanks!!