VBA replace paste command with Paste Special option

VBA replace paste command with Paste Special option

Post by enda_ridg » Tue, 02 Dec 2003 17:42:15


Hello,

I would be grateful for help with this problem.

I would like a VBA macro to replace my default paste command with the
Paste Special option to paste as Unformatted Unicode Text. I want this
mascro, which I have recorded below, to globally replace all calls to
regular paste in the way that, for example, the FileNew() command can
be replaced.

How do I do this?

Thanks,

Enda

Sub PasteAsUnformattedUniCode()
'
' Macro1 Macro
' Macro recorded 01/12/2003 by Enda Ridge
'
Selection.PasteSpecial Link:=False, DataType:=20,
Placement:=wdInLine, _
DisplayAsIcon:=False
End Sub
 
 
 

VBA replace paste command with Paste Special option

Post by Jonathan W » Tue, 02 Dec 2003 22:32:03

Hi Enda

If you rename the macro EditPaste, it will be used in place of the standard
paste command.

--
Regards
Jonathan West - Word MVP
http://www.yqcomputer.com/
Please reply to the newsgroup

 
 
 

VBA replace paste command with Paste Special option

Post by enda_ridg » Sat, 06 Dec 2003 18:11:19

Thanks Jonathan,

Enda