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
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?
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?
Related:
- Hyperlink linked to another workbook
- How to recover instagram account linked with facebook - Guide
- Hyperlink in gmail - Guide
- How to remove hyperlink in word - Guide
- How to open a local file link on iphone - Guide
- How to block someone on linked in - Guide
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
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
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
