Results 1 to 5 of 5
  1. #1
    Star Lounger
    Join Date
    Feb 2003
    Location
    DC Metro, District Of Columbia, USA
    Posts
    61
    Thanks
    0
    Thanked 0 Times in 0 Posts

    excel mailto in empty cells?!@ (xl 2002(xp))

    Hi all:
    I received an xls with over 300 rows of data, mixed with lots of blank cells within data cells. Mousing over blank cells, I get the 'finger' and mailto:xxx. Different cells and different names, but, still the finger and mailto in most of these blank cells. I tried to manually unhyperlink, tedious et al. Where do I turn off this feature (globally, of course), or ??

  2. #2
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: excel mailto in empty cells?!@ (xl 2002(xp))

    Hello, rujlopez? (Sorry, couldn't resist.) I don't have access to XL XP right now, but in WORD 2000 I can select Tools, Autocorrect, Autoformat, UNcheck "Internet and Network Paths with Hyperlinks". See if there is something similar in XL XP. (I thought I had heard that this setting spills over to all Office Apps, but can't reproduce it.)

    For those already in place that you want to "un-hyperlink" but not delete, select the range and run this macro:

    Sub UnhyperLink
    Selection.Hyperlinks.Delete
    End Sub

    Hope this helps with XP.
    -John ... I float in liquid gardens
    UTC -7ąDS

  3. #3
    Star Lounger
    Join Date
    Feb 2003
    Location
    DC Metro, District Of Columbia, USA
    Posts
    61
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: excel mailto in empty cells?!@ (xl 2002(xp))

    R U? Am I? I am. I really am. Really. No, really.<grin>. Thanks and I will try it tomorrow when I return to work. I do miss 2K, XP moved lots o' menu and rt. click shortcuts around <sigh>.

  4. #4
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: excel mailto in empty cells?!@ (xl 2002(xp))

    Checked XP, and it's right there in the menu, albeit a very slight wording difference.
    -John ... I float in liquid gardens
    UTC -7ąDS

  5. #5
    Star Lounger
    Join Date
    Feb 2003
    Location
    DC Metro, District Of Columbia, USA
    Posts
    61
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: excel mailto in empty cells?!@ (xl 2002(xp))

    JohnFB: tanx * much ;^) My IA person was doing the manual unlinky thing. Now I will have to avoid her when she has that 'I need Excel help again, jl' look in her eyes <grin>. i(really)amjlopez<g>.

Posting Permissions

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