View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Is it possible to store multiple hyperlinks in a cell for Excel

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