hyperlinks

[Soz]

Is there any way to remove hyperlinks in cells other than right clicking on
each individual cell and selecting remove hyperlink?

 

[Peo Sjoblom]

Are these from insert>hyperlinks? If so you can copy an empty cell,
select the area with hyperlinks, do edit>paste special and select multiply.
That will remove links, now while still selected just deletethe text. If you
want to remove
links from the hyperlink function just delete it. Finally if you do this
often you might want to run a macro like this from Bernie Deitrick


Sub RemoveAllHyperLinks2()
Dim mySht As Worksheet
Dim myHyper As Hyperlink
For Each mySht In Worksheets
For Each myHyper In mySht.Hyperlinks
myHyper.Range.ClearContents 'To remove completely
Next myHyper
Next mySht
End Sub

 

[David McRitchie]

Hi Peo and Soz, (courtesy email copy to Soz)
I wouldn't think there would be much use or safety in removing
all hyperlinks in all worksheets let along removing ALL of the cell
content of any cell containing a hyperlink in all worksheets.

The OP wanted a simpler method than using Ctrl+K to remove
the hyperlink and only the hyperlink, as I read it. The poster was
therefore referring to inserted hyperlink and automatically generated
links rather than HYPERLINK Worksheet Functions.

The following will remove only the hyperlinks from a selection of cells.
By using Ctrl+A the selection can be the entire worksheet so only
need one macro..

Sub DelHyperLinks()
'--Removes all hyperlinks from a selection
Selection.Hyperlinks.Delete
End Sub

To remove only the hyperlinks from ALL worksheets, which I wouldn't
think there would be much use for. Know your data and what you are doing..

Sub RemoveAllHyperLinksInWB()
'-- Removes all hyperlinks from all worksheets in active workbook
Dim mySht As Worksheet
For Each mySht In Worksheets
mySht.Hyperlinks.Delete
Next mySht
End Sub

For information on installing / using a macro see
http://www.mvps.org/dmcritchie/excel/getstarted.htm

For more information on hyperlinks see my
Build Table of Contents, similar listings, working with Hyperlinks
http://www.mvps.org/dmcritchie/excel/buildtoc.htm

Are these from insert>hyperlinks? If so you can copy an empty cell, [clipped]

Is there any way to remove hyperlinks in cells other than right clicking
on > each individual cell and selecting remove hyperlink?