Results 1 to 8 of 8
  1. #1
    New Lounger
    Join Date
    Dec 2001
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Excel 2000 (SR-1)

    How the heck do your turn off the automatic hyperlink function in Excel when typing web addresses?

  2. #2
    2 Star Lounger
    Join Date
    May 2002
    Location
    Midland, Michigan, USA
    Posts
    133
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel 2000 (SR-1)

    I'll have a look at home on my Excel 2k, but in Excel 97 you can right-click the cell | Hyperlink | Edit Hyperlink..., and click the Remove Link button.

    I'm sure you know that you could do that. Hold on, and someone else will probably post some code to help you out.

    BTW - why isn't this posted in the EXCEL group? It seems to be better suited for over there; for instance, look at <!post=post #134399,134399>post #134399<!/post> or search all Excel groups for 'hyperlink'.

    <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

  3. #3
    New Lounger
    Join Date
    Dec 2001
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel 2000 (SR-1)

    Thanks for the reply. So right clicking is great for one cell, however my users have databases containing addresses which they are adding to on a regular basis and they are finding extremely annoying to have the hyperlink created in the first place. I've also tried deleting the Hyperlink style which it automatically applies, but this is simply recreated when the next web address is typed in.

    So I ask again, how can I turn off the annoying automatic function in Excel?

  4. #4
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Excel 2000 (SR-1)

    There is an option in XL 2002 to switch it off via the AutoCorrect settings. However I cannot see the same settings available in 2000. If you use the text qualifier (a single quoute - ' ) before the actual web address, it should prevent the hyperlink being applied.

    Andrew C

  5. #5
    New Lounger
    Join Date
    Dec 2001
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel 2000 (SR-1)

    Thanks Andrew. Typing in a single quote works well... that is until you use the data in a Mail Merge where I would have to remove all those unwanted quotation marks.

    I would just love to turn the automatic function off. Any other suggestions greatfully received.

  6. #6
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Excel 2000 (SR-1)

    I'm not certain, but would have thought the single quote would be ignored and not offered by excel as part of the cell value. However if you are not adverse to a VBA solution you could try

    Private Sub Worksheet_Change(ByVal Target As Range)
    Target.Hyperlinks.Delete
    End Sub

    Right click on the Sheet tab(s) involved, select View Code and enter the above in codepane.

    Andrew

  7. #7
    2 Star Lounger
    Join Date
    May 2002
    Location
    Midland, Michigan, USA
    Posts
    133
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel 2000 (SR-1)

    Uh, oh. Microsoft's KB Q233073 has this to say about hyperlink and email addresses:
    <hr>When you type an entry in your worksheet that begins with any of the following prefixes, Microsoft Excel creates a hyperlink:

    http://
    www.
    ftp://
    mailto:
    file://
    news:

    Excel also creates a hyperlink when you type an e-mail address in the following format:
    user name @ company name .com
    Excel does not provide a built-in method to override this behavior. However, this article contains a two sample methods that you can use to prevent Excel from automatically creating hyperlinks. <hr>

    Perhaps Method 2 will work for you (Method 1 was the recommendation to use the apostrophe)

  8. #8
    New Lounger
    Join Date
    Dec 2001
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel 2000 (SR-1)

    Thank you.

    I'll certainly pass this information along to my users, I'll think I'll steer clear of the VBA option though. It amazes me that you can't just turn the option off, but at least I now know I wasn't missing it. Thanks again.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •