Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 271
  • Last Modified:

Excel 2007: Hyperlinks

Hello Experts,

    I'm curious, is it possible to hyperlink the contents of a cell to open up two different URL's when clicked on?  I have a topic I'm using and have created a hyperlink from that topic but there are several good references I'd like to point it to.  

    In a perfect world, my reader could just click on the topic hyperlink and multiple tabs would open showing it's reference URL's.  Is this possible in Excel?
  • 2
1 Solution
I don't think so. You could link to another location with further links in separate cells perhaps?
You can simulate this with the following code.

Take a look at the sample attached file. Click on cell A1 and it will open 2 tab on your browser.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

    If Target.Address = "$A$1" Then
        ActiveWorkbook.FollowHyperlink Address:="http://www.google.com", NewWindow:=True
        ActiveWorkbook.FollowHyperlink Address:="http://www.yahoo.com", NewWindow:=True
    End If
End Sub

Open in new window

itsmevicAuthor Commented:
Very cool jppinto!  Thank you!  I'm wondering, could one perhaps expend that to say open three or even four by just adding additional  "ActiveWorkbook.FollowHaperlink...."  lines?  Not that it's a big deal as two is more than sufficient just curious.  Awesome input thank you again!  
Yes, just add additional lines to your code and it will open additional tabs on your browser.

Featured Post

Free recovery tool for Microsoft Active Directory

Veeam Explorer for Microsoft Active Directory provides fast and reliable object-level recovery for Active Directory from a single-pass, agentless backup or storage snapshot — without the need to restore an entire virtual machine or use third-party tools.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now