More Help Needed From Aladdin

[Harley]

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.

 

[Aladin Akyurek]

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

 

[Harley]

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.

 

[Aladin Akyurek]

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.