Hyperlink linked to another workbook

Closed
kat - Jun 4, 2010 at 10:01 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jun 5, 2010 at 06:25 AM
Hello,

I have a cell that contains a number and it contains a hyperlink when you click on it. This workbook is linked to another excel workbook where that cell is linked to another cell in the other workbook. (The workbooks look identicle to each other, except for the hyperlink). I am unable to get the hyperlink to link to the other workbook as well. Is this possible, or do I need to add the hyperlink again to the second workbook?

1 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Jun 5, 2010 at 06:25 AM
If you were trying to click on link on book 1 to a link on book 2 that should take you to book3 on its own, it will not happen on basis of link. You may use macro to accomplish some thing like that. You would have to code for the event

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

End Sub

on the book 2, sheet where the 2nd link is located

DISCLAIMER: I have not tested the proposed solution
0