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??
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
Insert>Module 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" <[email protected]> wrote in message news:[email protected]...
>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??
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks