Mass Remove of Hyperlink

M

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
 
F

Frank Kabel

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

removes all hyperlinks from the selected cells
 
A

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,
 
Top