View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
TonyM TonyM is offline
external usenet poster
 
Posts: 3
Default code a macro to go to a specific website

Rhonda

the following code will create a hyperlink in the active
cell, then take you to the webpage:-

Sub testHyperlink()

ActiveSheet.Hyperlinks.Add Anchor:=Selection,
Address:= _
"http://communities.microsoft.com/newsgroups/defaul
t.asp?
icp=Prod_Office&sLCID=US&newsgroup=microsoft.publi c.word.ne
wusers" _
, TextToDisplay:="test"
Selection.Hyperlinks(1).Follow NewWindow:=False,
AddHistory:=True

End Sub

hth,

Tony


-----Original Message-----
I wanted to know what line of code to use to make a macro
go to a specified web site?

Thanks!!!
.