PC Review


Reply
Thread Tools Rate Thread

3 different hyperlinks attached to the same cell?

 
 
Dan Tabla
Guest
Posts: n/a
 
      7th Jan 2009
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 With Quote
 
 
 
 
Bob Umlas, Excel MVP
Guest
Posts: n/a
 
      7th Jan 2009
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 With Quote
 
Dan Tabla
Guest
Posts: n/a
 
      8th Jan 2009
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 With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
documents attached using hyperlinks Beth W. Microsoft Frontpage 1 13th Jun 2008 08:11 PM
Need to get cell input message be attached to cell R Microsoft Excel Misc 3 21st Dec 2007 03:50 PM
Excel Hyperlinks- cell content v. hyperlinks =?Utf-8?B?aGVycGV0YWZhdW5h?= Microsoft Excel Misc 2 23rd May 2006 04:39 AM
Why do hyperlinks change in attached documents =?Utf-8?B?VGVzdGVy?= Microsoft Outlook Discussion 1 12th Aug 2005 03:19 PM
Printing attached hyperlinks and objects =?Utf-8?B?bGVl?= Microsoft Access 0 2nd Dec 2003 11:06 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 03:16 PM.