Removing Hyperlinks

  • Thread starter Thread starter Shamless Self Promotion
  • Start date Start date
S

Shamless Self Promotion

I've got a few sheets which have lots of hyperlinks in them. I only want
text.

Is there a quick way of changing hyperlinks to text?


ms_excel_challenged!
 
Hi "Shameless"

I don't think you can do this for all worksheets without vba.

Here's a VBA approach:

Sub RemoveAllHyperLinks()
Dim Sh As Worksheet
For Each Sh In Worksheets
Sh.Cells.Hyperlinks.Delete
Next Sh
End Sub

This can be placed in a module in the offending workbook or in your
Personal.xls file if you use it frequently.

To prevent further entries being hyperlinked use:

Tools > AutoCorrect Options
AutoFormat as you type tab
Remove check from Internet and network path with hyperlinks
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
the autocorrect part do prevent hyperlinks from being created
is in Excel 2002 and above.
 
Back
Top