Strange problem with hyperlinks!

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Susie - 27 Feb 2007 21:51 GMT

Some time well over a year ago, through some weird accident that no
one has ever been able to explain, hyperlinks scattered themselves
across a very large spreadsheet. There are two columns of email
addresses that are supposed to be hyperlinks, but now data in several
other cells seems to be linked to these email addresses. It appears
that each cell randomly got an address to link to. I don't know how
or why this happened, but now it is my duty to fix the thing. Rather
than going over more than 6000 rows to see which cells have links and
which ones don't and individually removing the links from the ones
that do, is there a way to maybe select an area or column and just
have it remove whatever links might be in that area?

Thanks in advance for the help!

~S

Reply to this Message

Geoff Lilley - 27 Feb 2007 22:51 GMT

> Some time well over a year ago, through some weird accident that no
> one has ever been able to explain, hyperlinks scattered themselves
[quoted text clipped - 11 lines]
>
> ~S

I'd recommend using this macro:
Sub ZapHyperlinks()
For x = 1 To ActiveWorkbook.Sheets.Count
Sheets(x).Select
Cells.Hyperlinks.Delete
Next
End Sub

Signature

HTH
Cheers
Geoff

--
Posted via a free Usenet account from http://www.teranews.com

Reply to this Message

JE McGimpsey - 28 Feb 2007 01:25 GMT

> Some time well over a year ago, through some weird accident that no
> one has ever been able to explain, hyperlinks scattered themselves
[quoted text clipped - 7 lines]
> that do, is there a way to maybe select an area or column and just
> have it remove whatever links might be in that area?

See

http://www.mcgimpsey.com/excel/nohyperlinks.html

Reply to this Message

Mac Forum / Applications / Excel / February 2007

Strange problem with hyperlinks!