Need to create custom buttom

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

MLD - 06 Apr 2005 17:15 GMT

I have a user who wants a custom button to ">Edit>Paste Special>Paste
Unformatted Text". If I record a macro and assign for this, wont it record
the specific document and not be available for whatever is on the clip
board? I'm not a strong VBA person.
Please advise?
Thanks,
-Monica

Reply to this Message

Graham Mayor - 06 Apr 2005 17:42 GMT

The code I use is -

Sub PasteUnfText()
On Error GoTo oops
Selection.PasteSpecial DataType:=wdPasteText, Placement:= _
wdInLine
End
oops:
Beep
End Sub

See http://www.gmayor.com/installing_macro.htm for instructions on its
deployment.

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> I have a user who wants a custom button to ">Edit>Paste Special>Paste
> Unformatted Text". If I record a macro and assign for this, wont it
[quoted text clipped - 3 lines]
> Thanks,
> -Monica

Reply to this Message

MLD - 06 Apr 2005 19:43 GMT

Thanks Graham!! Its perfect!!
You rock!!

> The code I use is -
>
[quoted text clipped - 17 lines]
> > Thanks,
> > -Monica

Reply to this Message

Graham Mayor - 07 Apr 2005 07:23 GMT

As my friend and fellow MVP Greg Maxey said recently - at my age I only roll
;)

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> Thanks Graham!! Its perfect!!
> You rock!!
[quoted text clipped - 28 lines]
>>> Thanks,
>>> -Monica

Reply to this Message