accelerator for paste special in excel 2000

[vishwa]

How to assign short cut keys to paste special in excel
2000

 

[Frank Kabel]

Hi
one way:
- create/record a macro for paste special
- assign a shortcut to this macro (in the macro dialog)

 

[James Silverton]

Hi
one way:
- create/record a macro for paste special
- assign a shortcut to this macro (in the macro dialog)

I did just that some time ago but, altho' I did do an unformatted
paste while recording the macro, I had to edit it to get an
unformatted paste. For the record, the operative and only (apart from
the usual subroutine delimiters) line in the macro should be:-

Selection.PasteAndFormat wdFormatPlainText