Hyperlink in Excel 2010

[jeff17408]

I have a cell that I would like to Hyperlink to another cell in a separate worksheet in the same workbook that also contains a Hyperlink. I don't want the Hyperlink address to show in the cell but rather put some other text such as "Open Addendum Folder". When clicking on the "Open Addendum Folder" on the one worksheet, I want it to open the Hyperlink that is on the referenced worksheet - in the same workbook. Any help on writing the formula would be GREATLY appreciated! Thank you!

[XOR LX]

Not quite sure what you mean here. As far as I know there's no way to set the reference in one hyperlink to that which is contained within another hyperlink formula.

I do know that you can reference another cell's text entry and use that in your hyperlink, so that, e.g.

=HYPERLINK(INDIRECT(CELL("address",Sheet2!A1)),"Open Addendum Folder")

would work providing Sheet2!A1 contains the full location of the file you want opened (in text format), e.g.

[C:\Documents and Settings\My Documents\Miscellany\Test.xlsx]Sheet1!A1

Other than that I'll have to pass.

Regards

[jeff17408]

Unfortunately, that didn't quite do what I needed. Say for instance there is a hyperlink in Cell A6. How would I insert the text "Open Addendum Folder" in cell R54 so when I clicked on it, it would open the Hyperlink in A6? Maybe that is a little better explanation.

[ARGK]

Hi
Follow these steps:
1. Put a hyperlink in SHeet 1 Cell A1 pointing to Sheet 2 Cell A1.
2. In Sheet 2 Cell A1 insert a hyperlink to your document you wish to open.
3. When in Sheet 2 right click on the Tab name and select View Code then cut and past the following small piece of code into that sheet and close it:

Private Sub Worksheet_Activate()
ActiveWorkbook.FollowHyperlink Address:=Range("A1"), NewWindow:=True
End Sub

4. Save the workbook and go to Sheet 1 and click on the Hyperlink in Cell A1.
The document linked from Sheet 2 Cell A1 will nopw open.
Hope this helps.
Good luck.
Tony

[jeff17408]

Thank you so much!! That worked!