Can I have mulitple web page results from a Hyperlink?
 

Is it possible to have two/more web pages come up for one hyperlink command /
is there a 2nd function you use in conjuction with? (if, and, range:range,
array?)

=HYPERLINK((www.x.com),HYPERLINK(www.y.com),"b")
=HYPERLINK(HYPERLINK(www.x.com),HYPERLINK(www.y.com),"b"))

Don't think =And( was going to work, Thanks

Not that I know of. Are you expecting both pages to open when you click on
the hyperlink ? you could do that with a macro... something like

Sub OpenLinks()
With ActiveWorkbook
.FollowHyperlink Address:="http://www.yahoo.com", NewWindow:=True
.FollowHyperlink Address:="http://www.google.com", NewWindow:=True
End With
End Sub

--
Regards,

Juan Pablo González
Excel MVP

"nastech" wrote in message
...
Is it possible to have two/more web pages come up for one hyperlink
command /
is there a 2nd function you use in conjuction with? (if, and,
range:range,
array?)

=HYPERLINK((www.x.com),HYPERLINK(www.y.com),"b")
=HYPERLINK(HYPERLINK(www.x.com),HYPERLINK(www.y.com),"b"))

Don't think =And( was going to work, Thanks

Thankyou, I will try that, yes I am trying to open two web pages with one
click.
I will check out macro's / if that will all some kind of wildcards:
to try that for multiple hyperlinks, that all go to the same core address,
but have different variables in the center, e.g.:
=HYPERLINK($O$6&M99&$O$7,"1")
=HYPERLINK($P$6&P99&$P$7,"2")

To be a combination of both, for thousands of links, will need to reference
each line, with 2 HYPERLINKS, in the sheet. Thankyou, -Nastech

"Juan Pablo González" wrote:

Not that I know of. Are you expecting both pages to open when you click on
the hyperlink ? you could do that with a macro... something like

Sub OpenLinks()
With ActiveWorkbook
.FollowHyperlink Address:="http://www.yahoo.com", NewWindow:=True
.FollowHyperlink Address:="http://www.google.com", NewWindow:=True
End With
End Sub

--
Regards,

Juan Pablo González
Excel MVP

"nastech" wrote in message
...
Is it possible to have two/more web pages come up for one hyperlink
command /
is there a 2nd function you use in conjuction with? (if, and,
range:range,
array?)

=HYPERLINK((www.x.com),HYPERLINK(www.y.com),"b")
=HYPERLINK(HYPERLINK(www.x.com),HYPERLINK(www.y.com),"b"))

Don't think =And( was going to work, Thanks

tried, but am not fluent in creating macro's "coding"? how do I enter
reference to 2 pre-existing hyperlinks, in the macro / add to each line (will
make a new column if have to).

"nastech" wrote:

Thankyou, I will try that, yes I am trying to open two web pages with one
click.
I will check out macro's / if that will all some kind of wildcards:
to try that for multiple hyperlinks, that all go to the same core address,
but have different variables in the center, e.g.: CORRECTION:
=HYPERLINK($O$6&M99&$O$7,"1")
=HYPERLINK($P$6&M99&$P$7,"2")

To be a combination of both, for thousands of links, will need to reference
each line, with 2 HYPERLINKS, in the sheet. Thankyou, -Nastech

"Juan Pablo González" wrote:

Not that I know of. Are you expecting both pages to open when you click on
the hyperlink ? you could do that with a macro... something like

Sub OpenLinks()
With ActiveWorkbook
.FollowHyperlink Address:="http://www.yahoo.com", NewWindow:=True
.FollowHyperlink Address:="http://www.google.com", NewWindow:=True
End With
End Sub

--
Regards,

Juan Pablo González
Excel MVP

"nastech" wrote in message
...
Is it possible to have two/more web pages come up for one hyperlink
command /
is there a 2nd function you use in conjuction with? (if, and,
range:range,
array?)

=HYPERLINK((www.x.com),HYPERLINK(www.y.com),"b")
=HYPERLINK(HYPERLINK(www.x.com),HYPERLINK(www.y.com),"b"))

Don't think =And( was going to work, Thanks