Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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! |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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! |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to populate cell based on drop-down list attached to the SAME cell? | Excel Discussion (Misc queries) | |||
How to keep linked cell attached to it's source cell? | Excel Discussion (Misc queries) | |||
Graph attached into cell | Excel Worksheet Functions | |||
Need to get cell input message be attached to cell | Excel Discussion (Misc queries) | |||
Timestamping a cell with a Link already attached to it. | Excel Worksheet Functions |