A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Links and Linking
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Kill the hyperlinks!



 
 
Thread Tools Display Modes
  #1  
Old April 14th, 2004, 02:36 PM
Jax
external usenet poster
 
Posts: n/a
Default Kill the hyperlinks!

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?
  #2  
Old April 14th, 2004, 02:53 PM
Frank Kabel
external usenet poster
 
Posts: n/a
Default Kill the hyperlinks!

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)


--
Regards
Frank Kabel
Frankfurt, Germany


Jax wrote:
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?


  #3  
Old April 14th, 2004, 09:56 PM
EL
external usenet poster
 
Posts: n/a
Default Kill the hyperlinks!


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
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?
.

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 07:57 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.