I've copied and pasted a bunch of names and dates from webpages into a
number of Word 2004 for Mac documents and it's created a mess of
hyperlinks!
How can I get rid of them all? I know I can go in and delete each
individual
hyperlink. But there are dozens and dozens at this point in a number of
docs. Is there a way to:
1. Remove all the hyperlinks from a Word document?
2. Set a preference or something so hyperlinks aren't created by a simple
pasting in of a word or two from a website?
Many thanks!
Here's what I found at
http://www.j-walk.com/ss/excel/usertips/tip031.htm
Removing or avoiding automatic hyperlinks
You may have discovered that Excel 2000 supports automatic cell hyperlinks.
Whenever you type something that resembles a URL or an e-mail address into a
cell, this feature automatically converts the text into a clickable
hyperlink. But what if you don't want to create a hyperlink?
If you use Excel 2000, you're out of luck. There is no way to turn this
potentially annoying feature off. But you can, however, override it. If
Excel creates a hyperlink from your cell entry, click the Undo button (or
press Ctrl-Z) to restore the cell's contents to normal text. Or, you can
precede the cell entry with an apostrophe.
Note: If you're using Excel 2002, you can turn automatic hyperlinks on or
off in the AutoCorrect dialog box
Surprisingly, Excel doesn't provide a direct way to remove all hyperlinks on
a worksheet. In fact, the only way to accomplish this is one cell at a time:
Activate the cell that contains the hyperlink, right-click, and then select
Hyperlink, Remove Hyperlink. Unfortunately, this command is available only
when you have selected a single cell. To quickly deactivate all hyperlinks,
you need to use a macro.
To create the macro, press Alt-F11 to activate the Visual Basic Editor,
select Insert, Module to insert a new VBA module into your project, and then
enter the following code:
Sub ZapHyperlinks()
Cells.Hyperlinks.Delete
End SubWhen you execute the ZapHyperlinks macro, all hyperlinks on the
active sheet are deleted and replaced with normal text.
/ Fredrik
