Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Sep 2001
    Location
    Etobicoke, Ontario, Canada
    Posts
    198
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Hyperlinks (9.0.4402 SR-1)

    Is there a way to prevent Excel from converting email addresses to hyperlinks by default?

    Also, is there a way to remove all the email address hyperlinks from a spreadsheet?

  2. #2
    Star Lounger
    Join Date
    Jun 2002
    Posts
    98
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Hyperlinks (9.0.4402 SR-1)

    I don't know how to turn off that "feature" to prevent them from appearing. Here's some VBA code to remove them though:

    <pre>Sub DeleteAllHyperlinks()
    For Each xlink In ActiveSheet.Hyperlinks
    xlink.Delete
    Next xlink
    End Sub
    </pre>


    You could get more precise if you only want to remove email hyperlinks by putting a condition in there like:
    <pre>If Left(xlink.Address,6)="mailto" then xlink.Delete</pre>

    __________________________________________________ ____
    <img src=/S/nun.gif border=0 alt=nun width=20 height=20> Sister Dory
    Our Lady of Perpetual Help, Holstein Falls, Wisconsin, USA

  3. #3
    3 Star Lounger
    Join Date
    Nov 2001
    Location
    Upstate, South Carolina, USA
    Posts
    253
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Hyperlinks (9.0.4402 SR-1)

    In O2002: Go to Tools | AutoCorrect options and select the "Autoformat as you type" tab. Clear the "Internet and network paths with hyperlinks" check box. Works in all O2002 apps.

    I thought that in O2000 one could disable these hyperlinks in Word and the behavior would roll over to Excel, too. Alas, doesn't seem to work.

    Sorry...

    - Al
    Al
    "Do or do not do. There is no try." -- Yoda
    <img src=/S/flags/USA.gif border=0 alt=USA width=30 height=18>

Posting Permissions

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