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.