Paste Special Unformatted Text

macropod · #2 02-25-2011, 01:20 AM

Hi Ken,

Each Office App could have a macro added to the default template (eg Normal.dotm in Word) that is activated via a keyboard shortcut. It should be possible to find an unused shortcut combo that's available across all (or at least most) applicable Office Apps.

A suitable macro for Word is:

Code:

Sub PasteUnformattedText()
' The next line is in case there's nothing in the Clipboard
On Error Resume Next
Selection.PasteSpecial DataType:=wdPasteText
End Sub

And, for Excel:

Code:

Sub PasteUnformattedText()
    On Error Resume Next
    Selection.PasteSpecial Paste:=xlPasteValues
End Sub

If you prefix the subs with 'Private', they won't show up in the macros list.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Macro to paste unformatted text	Andacar	Word	2	01-05-2011 09:15 PM
Paste Special Link no longer working	MrsMoe	PowerPoint	0	12-20-2010 10:54 PM
special copy/paste	iconofsin	Excel	1	09-15-2010 12:10 AM
Using Paste/Special wih Excel data	chickasaw	PowerPoint	0	02-05-2010 10:00 PM
Copy and paste special	Dace	Excel	2	02-16-2009 12:18 PM