VBA replace paste command with Paste Special option

E

Enda

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
 
J

Jonathan West

Hi Enda

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

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

Top