accelerator for paste special in excel 2000

  • Thread starter Thread starter vishwa
  • Start date Start date
Hi
one way:
- create/record a macro for paste special
- assign a shortcut to this macro (in the macro dialog)
 
Frank Kabel said:
Hi
one way:
- create/record a macro for paste special
- assign a shortcut to this macro (in the macro dialog)
Click to expand...

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel graphs change when pasted into Publisher - Metafiles change? 0
Linking Excel charts in Powerpoint 0
Paste link 2003 excel charts into word 2007 1
Copy/Paste charts as object inside excel 1
Excel to Word : Paste special>Paste Link> Excel Chart Obj doesn't 0
Cut & Paste in Excel without erasing cell borders? 1
Paste Special Values 2
Keyboard Shortcuts for Paste Special Values and Formats 2

Back
Top