How do I remove ALL hyperlinks from a large worksheet?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I remove numerous Hyperlinks all at once within a worksheet 3
Hyperlinks changed by Excel again! 5
How would I change all hyperlinks at once? 1
How do I make a global change of Hyperlink addresses? 1
Hyperlink failure after saving document 2
E-mailing a worksheet 1
Maintaining hyperlinks when I move Excel files to another location 1
Maintain hyperlink when moving excel files 1

Back
Top