control "paste special" options

[gv malaysia]

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/com...=microsoft.public.office.developer.automation

 

[Pranav Wagh[MSFT]]

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

--------------------