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
        Related:         
- Hyperlink linked to another workbook
 - How to recover instagram account linked with facebook - Guide
 - How to hyperlink in gmail - Guide
 - Excel hyperlink to another sheet - Guide
 - How to remove hyperlink in word - Guide
 - Vba copy data from one workbook to another - 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