Prev: update links - source file open
Next: Closing workbook open as CSV
From: 101 for me on 18 Mar 2010 14:11
Can anyone write me a macro to open multiple (but not all) hyperlinks on a
worksheet, Thanks!
From: CLR on 18 Mar 2010 15:14
Maybe this.......

Sub OpenSome()
Range("A1").Select
Selection.Hyperlinks(1).Follow NewWindow:=False, AddHistory:=True
Application.WindowState = xlNormal
Range("A2").Select
Selection.Hyperlinks(1).Follow NewWindow:=False, AddHistory:=True
Application.WindowState = xlNormal
End Sub

Vaya con Dios,
Chuck, CABGx3


"101 for me" wrote:

> Can anyone write me a macro to open multiple (but not all) hyperlinks on a
> worksheet, Thanks!
From: Gary Brown on 18 Mar 2010 15:22
You need to know the name of the TextToDisplay property.
For example, when creating the link below, the TextToDisplay is 'Glenn Beck
Program'.
ActiveSheet.Hyperlinks.Add _
Anchor:=Selection, Address:= _
"http://www.glennbeck.com/", _
TextToDisplay:="Glenn Beck Program"

So to pick only specific hyperlinks, have a set of program lines such as...
ActiveSheet.Hyperlinks("Glenn Beck Program").Follow _
NewWindow:=False, AddHistory:=True

--
Hope this helps.
If it does, please click the Yes button.
Thanks in advance for your feedback.
Gary Brown



"101 for me" wrote:

> Can anyone write me a macro to open multiple (but not all) hyperlinks on a
> worksheet, Thanks!
From: 101 for me on 18 Mar 2010 16:03


"101 for me" wrote:

> Can anyone write me a macro to open multiple (but not all) hyperlinks on a
> worksheet, Thanks!

Works great, Thank you so much. Have a great day!
From: 101 for me on 18 Mar 2010 16:04

Thanks Gary, the other one worked but I can try your also. Have a great day.
"Gary Brown" wrote:

> You need to know the name of the TextToDisplay property.
> For example, when creating the link below, the TextToDisplay is 'Glenn Beck
> Program'.
> ActiveSheet.Hyperlinks.Add _
> Anchor:=Selection, Address:= _
> "http://www.glennbeck.com/", _
> TextToDisplay:="Glenn Beck Program"
>
> So to pick only specific hyperlinks, have a set of program lines such as...
> ActiveSheet.Hyperlinks("Glenn Beck Program").Follow _
> NewWindow:=False, AddHistory:=True
>
> --
> Hope this helps.
> If it does, please click the Yes button.
> Thanks in advance for your feedback.
> Gary Brown
>
>
>
> "101 for me" wrote:
>
> > Can anyone write me a macro to open multiple (but not all) hyperlinks on a
> > worksheet, Thanks!
 | 
Pages: 1
Prev: update links - source file open
Next: Closing workbook open as CSV