Power Query Course in Spanish
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 10 of 10

Thread: Email addresses in cells

  1. #1
    New Member
    Join Date
    Jan 2002
    Location
    Canada
    Posts
    42
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I have a column that contains email addresses. If I click on the cell, it brings up a blank email with the persons address in it. (Outlook Express).
    Is there a way to block that column from executing the email thing?

  2. #2
    Board Regular
    Join Date
    Apr 2002
    Location
    Cape Town,South Africa
    Posts
    234
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Yes there is.If you remove the Hyperlink from your Column,you will be able to browse in the column without going to the e-mail link

  3. #3
    New Member
    Join Date
    Mar 2002
    Location
    Australia
    Posts
    43
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    You can remove the hyperlinks one by one by right clicking on the cell and choosing remove hyperlink from the menu.

    If you have a whole column then the best way to get rid of the lot of 'em is to highlight the range and click on Format, Style and then select Normal from the list box at the top.

    Regards,

    Penfold

  4. #4
    New Member
    Join Date
    Jan 2002
    Location
    Canada
    Posts
    42
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    You know this is sooooo much easier than trying to figure out where to find the info in a mannual. Thanks so much for the prompt responses.

  5. #5
    New Member
    Join Date
    Jan 2002
    Location
    Canada
    Posts
    42
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Just an added note here Penfold, When trying to change the whole range by using styles, it did take the blue color and line underneath out, but it still links when clicked on. Unless I did something wrong, I guess to totally deactivate them, I'll have to do the right click thing individually. Feel free to correct me if I'm wrong.

  6. #6
    New Member
    Join Date
    Mar 2002
    Location
    Australia
    Posts
    43
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Good point, I hadn't really noticed as the main issue I had in the past was that it was blue and underlined!

    I can't readily find a method quicker than doing it one by one, but remember to use the extremely useful "Repeat" function in Excel (either Ctrl-Y or better still, F4). That is, do it once using the right click method and then arrow down one cell, hit F4, down, F4 etc etc.

    Penfold

  7. #7
    New Member
    Join Date
    Jan 2002
    Location
    Canada
    Posts
    42
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    That worked Pen. Thanks. I always feel so much smarter (advanced) if I can use an F key.


    [ This Message was edited by: Phylis Sophical on 2002-04-22 02:46 ]

  8. #8
    New Member
    Join Date
    Apr 2002
    Location
    Penny Weiss
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I have a column that's 700 entries long.. still no way to remove the hyperlink on a range??

  9. #9
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    83,653
    Post Thanks / Like
    Mentioned
    33 Post(s)
    Tagged
    6 Thread(s)

    Default

    On 2002-04-26 13:59, PennyWeiss wrote:
    I have a column that's 700 entries long.. still no way to remove the hyperlink on a range??
    Try ASAP-Utilities, free downloadable from:

    http://asap-utilities.com

    Aladin

  10. #10
    New Member
    Join Date
    Jan 2002
    Location
    Canada
    Posts
    42
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Just ran across this Penny:

    To create the macro, press Alt-F11 to activate the Visual Basic Editor, select Insert, Module to insert a new VBA module into your project, and then enter the following code:

    Sub ZapHyperlinks()
    Cells.Hyperlinks.Delete
    End Sub
    When you execute the ZapHyperlinks macro, all hyperlinks on the active sheet are deleted and replaced with normal text.

    found this at:
    http://j-walk.com/ss/excel/usertips/tip031.htm

    [ This Message was edited by: Phylis Sophical on 2002-04-26 21:16 ]

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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