Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Is it possible to store multiple hyperlinks in a cell for Excel 2003
|
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
No, but it is easy to get the same effect.
Put the hyperlinks in a column somewhere. In A1, put a Data Validation to allow you to pick one of the links. In B1 enter: =HYPERLINK(A1) So you click on A1 to pick the link and then click on B1 to activate the link. If you want to activate ALL the links, then use an Event macro. -- Gary''s Student - gsnu200825 "Kart" wrote: Is it possible to store multiple hyperlinks in a cell for Excel 2003 |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Try this code from Bob Umlas.
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 Gord Dibben MS Excel MVP On Fri, 9 Jan 2009 04:24:08 -0800, Kart wrote: Is it possible to store multiple hyperlinks in a cell for Excel 2003 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
multiple Hyperlinks one Excel cell? | Excel Worksheet Functions | |||
Multiple Hyperlinks in 1 Cell | Excel Programming | |||
Store Multiple Cell Values (Cell History) | Excel Programming | |||
How do I remove multiple hyperlinks in the same cell (Excel)? | Charts and Charting in Excel | |||
Excel should allow multiple hyperlinks in a single cell | Excel Discussion (Misc queries) |