View Full Version : control "paste special" options


gv malaysia
02-07-2006, 11:39 PM
when u use "paste special" in word/excel/etc, the default option is the same
as "paste". u have to manually choose a different option after clicking
"paste special". it would be great to be able to adjust the default option.
99% of the time i use "paste special" is to paste text only without any
formatting. if i could change the default to "unformatted text" then, when i
click "paste special" it will do just that straight away instead of offering
what option i want to use - meaning one less click to achieve the same
result. you could always have a button to reset and allow for all options to
be displayed.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/community/en-us/default.mspx?mid=952511c2-a675-4fe1-9be1-9bed360e3915&dg=microsoft.public.office.developer.automation

Pranav Wagh[MSFT]
02-12-2006, 07:23 AM
Hello,
I had a similler requiremet and the solution was simple.
Go to Tools -> Macro -> Visual Basic Editor.
Add a new macro in normal.dot(so that you can use it in all of the word
documents)
the macro code should be:

Sub PastePlain()
Selection.PasteAndFormat (wdFormatPlainText)
End Sub

assign a shortcut key to this macro(i assigned Alt+V), and you are done,
now you can always use Alt+V to paste plain text , if you are not
confortable with shortcut keys you can also assign a button for this macro.



Thanks & Regards
Pranav Wagh

"The Real Stuff Is oUT oF tHE bOX"

http://blogs.msdn.com/pranavwagh

--------------------
>Thread-Topic: control "paste special" options
>thread-index: AcYsP7u1/4Jjf3hRTlKcQgN2jd8PLg==
>X-WBNR-Posting-Host: 218.208.239.115
>From: "=?Utf-8?B?Z3YgbWFsYXlzaWE=?=" <gv
malaysia@discussions.microsoft.com>
>Subject: control "paste special" options
>Date: Tue, 7 Feb 2006 15:39:27 -0800
>Lines: 18
>Message-ID: <952511C2-A675-4FE1-9BE1-9BED360E3915@microsoft.com>
>MIME-Version: 1.0
>Content-Type: text/plain;
> charset="Utf-8"
>Content-Transfer-Encoding: 7bit
>X-Newsreader: Microsoft CDO for Windows 2000
>Content-Class: urn:content-classes:message
>Importance: normal
>Priority: normal
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
>Newsgroups: microsoft.public.office.developer.automation
>NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
>Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
>Xref: TK2MSFTNGXA01.phx.gbl
microsoft.public.office.developer.automation:12534
>X-Tomcat-NG: microsoft.public.office.developer.automation
>
>when u use "paste special" in word/excel/etc, the default option is the
same
>as "paste". u have to manually choose a different option after clicking
>"paste special". it would be great to be able to adjust the default
option.
>99% of the time i use "paste special" is to paste text only without any
>formatting. if i could change the default to "unformatted text" then, when
i
>click "paste special" it will do just that straight away instead of
offering
>what option i want to use - meaning one less click to achieve the same
>result. you could always have a button to reset and allow for all options
to
>be displayed.
>
>----------------
>This post is a suggestion for Microsoft, and Microsoft responds to the
>suggestions with the most votes. To vote for this suggestion, click the "I
>Agree" button in the message pane. If you do not see the button, follow
this
>link to open the suggestion in the Microsoft Web-based Newsreader and then
>click "I Agree" in the message pane.
>
>http://www.microsoft.com/office/community/en-us/default.mspx?mid=952511c2-a
675-4fe1-9be1-9bed360e3915&dg=microsoft.public.office.developer.automation
>