Mass Remove of Hyperlink

[Martha W. Stone]

I have a document with about 100 email addresses and each have been
automatically hyperlinked. I know how to go through and individually remove
the hyperlink, but can I do it on a mass level?

Thanks!

Martha

 

[Frank Kabel]

Hi Martha
try the following macro:
Sub RemoveHyperLinks()
selection.hyperlinks.delete
end sub

removes all hyperlinks from the selected cells

 

[Gord Dibben]

Martha

See David McRitchie's site for several manual and coded methods of removing
Hyperlinks en masse.

http://www.mvps.org/dmcritchie/excel/buildtoc.htm#hyp

Gord Dibben Excel MVP

 

[DDM]

Martha, just remove the hyperlink from one cell, then use the Format Painter
to remove it from the others.

DDM
"DDM's Microsoft Office Tips and Tricks"
www.ddmcomputing.com

 

[Alan]

Enter 1 in an empty cell
Right Click, Copy
Highlight all the cells with Hyperlinks using Ctrl held down
Right Click one of the highlighted cells
Paste Special > Multiply > OK

Don't highlight the whole sheet or all the empty cells will have a zero in
them,

Regards,