hyperlinks

[john.9.williams]

hi all
what is the code for hyperlinking to a webpage from vba, i know you can
insert a hyperlink ontp a worksheet but can you do it via code
regards
johny5

 

[Bob Phillips]

Here is an example

With Worksheets("Sheet3")
.Hyperlinks.Add Anchor:=.Range("A1"), _
TextToDisplay:="xlDynamic", _
Address:="http://www.xldynamic.com/"
End With


--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Tom Ogilvy]

Bob has shown you how to add a hyperlink. If you want to execute a
hyperlink without having it physically exist, look at the followhyperlink
method of the workbook object (not the followhyperlink event).