Thread: Shortcuts
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Kevin B Kevin B is offline
external usenet poster
 
Posts: 1,316
Default Shortcuts

For the macro offerred by FSt1 to work in all workbooks you'll want to place
it in the Personal.xls workbook so that it can be accessed by any workbook.
--
Kevin Backmann


"FSt1" wrote:

hi
create your own......
Paste this into a standart module.
Sub specialpaste()

ActiveCell.PasteSpecial Paste:=xlPasteValues, _
Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
End Sub
the go toolsmacromacrosclick the options button
assign your short cut key

regards
FSt1


"juanpablo" wrote:

Is there any addin for better support of shortcuts.
If I want to create a new book there is a shortcut CTRL+U, etc, but if I
want to paste special, or paste only values, ther are no shortcuts.

Thanks

JPG