Paste Special Unformatted Text

kenwpaul · #1 02-09-2011, 03:38 PM

The one option I use most in Office documents is Paste Special Unformatted Text. I've never seen a shortcut for that. Is there any way to set up a global key combination to accomplish that? I would want it to be consistant across all of the Office products.

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.

kenwpaul · #3 02-25-2011, 04:53 PM

Thanks, Paul. That looks promising.

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