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!!!
.
|