Hello -

Thanks so much for the response. Unfortunately this problem seems to lie
deeper. I just ran the macro and it's still happenening. If I run the macro
on the column with the actual email addresses, it WILL take out the
hyperlink... therefore I know the macro itself is working. However...when I
try to run the macro with the plain text that NEVER should have been linked
to random email addresses, it's still happening and the macro doesn't affect
it at all.

"Bill Manville" wrote:

Select the area which contains unwanted hyperlinks and run this macro:

Sub RemoveHyperlinks()
Selection.Hyperlinks.Delete
End Sub

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup