Bob, God bless you! It's working and very easy!
Compile succesfully!
"Bob Umlas, Excel MVP" wrote:
> 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
>
> "Dan Tabla" wrote:
>
> > 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!
|