Removing Hyperlinks

[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!

 

[Norman Harker]

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.

 

[David McRitchie]

the autocorrect part do prevent hyperlinks from being created
is in Excel 2002 and above.