Just can't do without it. I use it at least 10 to 15 times a day. Maybe more. Use it when I am translating a document in MS Word and picking up terms from various sources.
You find the translation of a term in an online dictionary, or in a Powerpoint file. You copy it (Ctrl + C) and wish to paste it (Ctrl + V) into the document you are translating in MS Word. You do so and find that the pasted text is in a format quite different from the format of the surrounding text. You have to select the offending text and change its font, the font size and sometimes the color. Uggh!
Copy this macro to your list of macros. I generally go to Tools/Macro/Macro and type PasteSpecial (the name of the macro), click Edit, and copy the macro so that there's only one "Sub" and one "End Sub." Save the macro, then place it on the menu bar at the top by: Alt + T(ools) + C(ustomize); click on Commands/Macros, scroll down until you find Normal.NewMacros.PasteSpecial and drag it right up to the top of the screen adjacent to the Help menu and drop it there. Don't close the Customize window. Right click on the item you have just deposited on the top of the screen, delete "Normal.NewMacros" from the longish phrase, and insert "&" in front of the "l" of Paste Special. Close the Customize window. That’s it. Now all you need to do to paste a glossary term into your text in Word is hit Alt + L instead of Ctrl + V. The text will be pasted in the same format as the surrounding text.
' PasteSpecial Macro
' Macro created 2006/11/18 by Gururaj Rao