3 different hyperlinks attached to the same cell?

  • Thread starter Thread starter Dan Tabla
  • Start date Start date
D

Dan Tabla

I need to attach 3 different hyperlinks to the same cell.
When I click on the cell I need to open 3 different web pages in the same
time.
Thanks a lot!
 
You can't do it with a regular hyperlink, but you can do it with VBA code,
something like this -- right-click the sheet tab, select View Code, put this
in (assumes the cell inquestion is F4):
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Address = "$F$4" Then
ThisWorkbook.FollowHyperlink "http://www.whatever.com",
NewWindow:=True
ThisWorkbook.FollowHyperlink "http://www.xyz.com", NewWindow:=True
ThisWorkbook.FollowHyperlink "http://www.abc.com", NewWindow:=True
End If
End Sub
 
Bob, God bless you! It's working and very easy!
Compile succesfully!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top