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

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)


wrote in message
oups.com...
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 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).

--
Regards,
Tom Ogilvy

wrote in message
oups.com...
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