How do I remove ALL hyperlinks from a large worksheet?
 

I use large spreadsheets that often contain hundreds of hyperlinks (e-mail
addresses). I know how to remove hyperlinks "globally" but not in Excel.
Is there a way??

Hi

In 2002/2003 you can turn it of

Tools Options Spelling
Press "AutoCorrect Options" Button
AutoFormat As You Type Tab
Remove Check from "Internet and network paths with hyperlinks"
OK
OK

If you have fill in a address and Enter to confirm you
can use Ctrl-Z to make it text.

Or start with a '

You can run this macro also to make text of all hyperlinks
in your worksheet

Sub test()
ActiveSheet.Hyperlinks.Delete
End Sub

Alt-F11
InsertModule from the menubar
paste the sub in there
Alt-Q to go back to Excel

If you do Alt-F8 you get a list of your macro's
Select "test" and press Run


--
Regards Ron de Bruin
http://www.rondebruin.nl


"RNewell" wrote in message ...
I use large spreadsheets that often contain hundreds of hyperlinks (e-mail
addresses). I know how to remove hyperlinks "globally" but not in Excel.
Is there a way??