Kill the hyperlinks!

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jax - 14 Apr 2004 14:36 GMT

I'm creating a mailing list in Excel. I have to add email
addresses, but don't want them as active hyperlinks
because this will upset the next phase of the project.

As soon as I type the addresses in, Excel 'helpfully'
converts them to hyperlinks. If I right click on them, I
can disable the hyperlink, but I'll have to do that over
5000 times!

Is there a way to stop Excel from creating the hyperlinks
in the first place?

Reply to this Message

Frank Kabel - 14 Apr 2004 14:53 GMT

Hi
depends on your Excel version:
Excel 2002+:
Goto 'Tools - Autocorrection' and choose the middle tab to disable this
feature

Prior to this version use one of the following alternatives:

a) Use the following macro to remove hyperlinks of a chosen selection
(after your data entry)
Sub RemoveHyperLinks()
selection.hyperlinks.delete
end sub

b) Without macro:
- Type the number 1 in a blank cell and copy this cell
- Select all your cells with hyperlinks
- goto 'Edit - Paste Special'
- choose multiply

c) Process the Worksheet_change event (see
http://www.mcgimpsey.com/excel/nohyperlinks2.html)

Signature

--
Regards
Frank Kabel
Frankfurt, Germany

> I'm creating a mailing list in Excel. I have to add email
> addresses, but don't want them as active hyperlinks
[quoted text clipped - 7 lines]
> Is there a way to stop Excel from creating the hyperlinks
> in the first place?

Reply to this Message

EL - 14 Apr 2004 21:56 GMT

Go to Tools --> AutoCorrect Options. Click on the tab
titled "AutoFormat As You Type." Uncheck the box next
to "Internet and network paths with hyperlinks."

>-----Original Message-----
>I'm creating a mailing list in Excel. I have to add email
[quoted text clipped - 9 lines]
>in the first place?
>.

Reply to this Message