Results 1 to 11 of 11
  1. #1
    2 Star Lounger
    Join Date
    Feb 2001
    Posts
    109
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Preventing Automatic Hyperlinks (XL 2000 SR1)

    Hello,

    Can anyone tell me how to prevent automatic hyper-links in Excel? For example if I type Joe@msn.com, Excel creates a hyperlink that will create a new e-mail. However, I do not want the hyperlink. I would like to turn this off globally because I will be typing in several items over the next few weeks.

    Thanks,

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Preventing Automatic Hyperlinks (XL 2000 SR1)

    Select Tools | AutoCorrect...
    In the AutoFormat As You Type tab, clear the "Internet and network paths with hyperlinks" check box.
    This is an Office-wide setting, it will affect Word, Excel, Outlook, ...

  3. #3
    2 Star Lounger
    Join Date
    Feb 2001
    Posts
    109
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Preventing Automatic Hyperlinks (XL 2000 SR1)

    I do not have the "AutoFormat As You Type" tab on the AutoCorrect dialog box in Excel. I do have that tab in Word and I did uncheck the box, but Excel is still formatting web address as hyperlinks.

    Regards,

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Preventing Automatic Hyperlinks (XL 2000 SR1)

    As far as I know it should be an Office-wide setting, but I use Office XP, not 2000. Perhaps another Lounger with Office 2000 can help.

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

    Re: Preventing Automatic Hyperlinks (XL 2000 SR1)

    In Office 2000, the option to switch off Hyperlinks is available in Word but not in Excel. Unfortunately the setting in Word does not seem to apply to Excel. You could remove Hyperlinks as they are type by trapping the WorksheetChange event as follows :

    Private Sub Worksheet_Change(ByVal Target As Range)
    Dim hl As Hyperlink
    If Target.Hyperlinks.Count Then
    For Each hl In Target.Hyperlinks
    hl.Delete
    Next
    End If
    End Sub

    To use this approach, copy the above code, right click on the relevant sheet tab and paste the code into the code pane.

    Andrew C

  6. #6
    Lounger
    Join Date
    Feb 2004
    Location
    Buffalo, New York, Wales
    Posts
    40
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Preventing Automatic Hyperlinks (XL 2000 SR1)

    I encountered this same problem a while back and could not find any available setting to rectify this. I did discover though, that if you put a space before the entry in the cell, excel disregards it as a hyperlink.

    Thats the best I can do for you.
    -yoyo

  7. #7
    2 Star Lounger
    Join Date
    Sep 2002
    Location
    the great white north..., Massachusetts, USA
    Posts
    104
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Preventing Automatic Hyperlinks (XL 2000 SR1)

    (Edited by HansV to provide link to MSKB article - see <!help=19>Help 19<!/help>)

    hello!

    i have the same problem and went looking for an answer, as i couldn't find one here. i found a sort of answer at microsoft. go look in the knowledge base; the number you want is <!mskb=233073>Microsoft Knowledge Base Article 233073<!/mskb>. it gives you a workaround of prefacing all entries with an apostrophe. i guess it's better than nothing, but you'd think that there'd be something easy and global for this, as a lot of people seem to want to do this. i guess microsoft just wants to make it hard for us, eh? hope his helps you. take care and God bless.

    smiles-
    ladyleadfoot!!!

  8. #8
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Preventing Automatic Hyperlinks (XL 2000 SR1)

    IN Excel 2000, you cannot prevent them. You can however hit control-z directly after entering the address in the cell, making the hyperlink disappear.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  9. #9
    2 Star Lounger
    Join Date
    Jul 2002
    Location
    London, United Kingdom
    Posts
    192
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Preventing Automatic Hyperlinks (XL 2000 SR1)

    I have the same problem when creating the company address list
    I use ASAP Utilities which is <img src=/S/free.gif border=0 alt=free width=30 height=15> . http://www.asap-utilities.com
    It has an option to remove hyperlinks from selected cells.

  10. #10
    2 Star Lounger
    Join Date
    Feb 2001
    Posts
    109
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Preventing Automatic Hyperlinks (XL 2000 SR1)

    I just wanted to thank all of you for your suggestions. They were all very good and would have done the job. However, I do not give up easily, so I wrote an add-in that can toggle the Auto Hyperlinks in Excel.

    I am posting the add-in for all to enjoy. The code is un-protected, but it is not commented very well. Please feel free to critique the code, but please be nice about it.

    When you load the Add-in a toolbar will be added with one button. If you do not wish to keep the toolbar, you can Press the ALT key and drag the button to a new toolbar and then delete the toolbar that the add-in created.

    If for some reason you loose the toolbar and button, just unload and then reload the add-in.

    I hope others find this useful.

    Regards,

  11. #11
    2 Star Lounger
    Join Date
    Feb 2001
    Posts
    109
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Preventing Automatic Hyperlinks (XL 2000 SR1)

    <P ID="nt"><font size=-1>(No Text)</font>

Posting Permissions

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