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!