Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: More Help Needed From Aladdin

  1. #1
    New Member
    Join Date
    Feb 2002
    Posts
    25
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    A week or so ago you were helping me with a problem I was having referencing hyperlinks in different worksheets.

    I went back and changed how I entered the hyperlinks in the first place. Instead of using the =HYPERLINK formula, I used the Insert-Hyperlink window. I now have all of my hyperlinks changed to this format.

    I went back and entered the UDF's that you provided me. And in the appropriate cell, I enter the formula =HYPERLINK(HLLink(Joe!B1),HLText(Joe!B1)). When this formula is entered, the link works (it takes me to the appropriate webpage) but the text is not correct. The text that appears is from cell B1 of the active page, not from the "Joe" worksheet.

    If I remove the latter part of the =HYPERLINK formula and keep only, =HYPERLINK(HLLink(Joe!B1)) the entire URL shows up in the cell. The link works but I need it to show only the name I've given the link, not the entire URL.

    Any more help? Thanks.

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

    Default

    On 2002-02-25 10:40, Harley wrote:
    A week or so ago you were helping me with a problem I was having referencing hyperlinks in different worksheets.

    I went back and changed how I entered the hyperlinks in the first place. Instead of using the =HYPERLINK formula, I used the Insert-Hyperlink window. I now have all of my hyperlinks changed to this format.

    I went back and entered the UDF's that you provided me. And in the appropriate cell, I enter the formula =HYPERLINK(HLLink(Joe!B1),HLText(Joe!B1)). When this formula is entered, the link works (it takes me to the appropriate webpage) but the text is not correct. The text that appears is from cell B1 of the active page, not from the "Joe" worksheet.

    If I remove the latter part of the =HYPERLINK formula and keep only, =HYPERLINK(HLLink(Joe!B1)) the entire URL shows up in the cell. The link works but I need it to show only the name I've given the link, not the entire URL.

    Any more help? Thanks.
    Using Insert|Hyperlink is mucho better (although I'm a bit frustrated about the problems that occur when we use the HYPERLINK function).

    I just did an Insert|Hyperlink in A2 sheet Joe: There was no display-name, so I typed myself "google":

    I have in A2 this "google" underscored and in blue: It's a clickable link.

    In B2 In Joe I've used: =HLLink(A2)

    and C2: =HLText(A2)

    What you get to see in A2:C2 is:

    {"google","http://google.com/","google"}

    The first "google" is the true hyperlink.

    In A2 of the sheet Mary I entered:

    =HYPERLINK(Joe!B2,Joe!C2)

    I get a clickable hyperlink with "google" as display-name.

    Can you check of this also works for you?

    Also, you could give me one of those with which you get wrong display-name?

    Aladin

  3. #3
    New Member
    Join Date
    Feb 2002
    Posts
    25
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Yes. I got it to work. I was entering the =HYPERLINK function incorrectly.

    However, as I expected, because I am using the =HYPERLINK function I cannot convert this document to .pdf format.

    I've recently discovered that the only way to get hyperlinks from Excel 2000 to work in .pdf format is to enter them using the insert hyperlink window.

    Oh well, at least I learned something from this whole experience.

    Thanks for all your help.

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

    Default

    You're welcoome.

    On 2002-02-25 12:53, Harley wrote:
    Yes. I got it to work. I was entering the =HYPERLINK function incorrectly.

    However, as I expected, because I am using the =HYPERLINK function I cannot convert this document to .pdf format.

    I've recently discovered that the only way to get hyperlinks from Excel 2000 to work in .pdf format is to enter them using the insert hyperlink window.

    Oh well, at least I learned something from this whole experience.

    Thanks for all your help.

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
  •