Hello ,
How can I activate a Link ( http://www.yahoo.com/ )
using VBA code in my Macro1 for example .
Thanks and Regards Gill

record macro clicking this llink in excel
you will get the code statements. modify to generalise.


"mihai" wrote in message
...
Hello ,
How can I activate a Link ( http://www.yahoo.com/ )
using VBA code in my Macro1 for example .
Thanks and Regards Gill

Thanks, R..VENKATARAMAN !
OK- I know that :
================================================== ==
Sub Macro1()
Sheets("AA").Select
Range("A1").Select
ActiveCell.FormulaR1C1 = "http://www.yahoo.com"
Range("A1").Select
Selection.Hyperlinks.Delete
ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:= _
"http://www.yahoo.com/", TextToDisplay:="Gill"
Range("A1").Select
Selection.Hyperlinks(1).Follow NewWindow:=True, AddHistory:=True
Range("A1").Select
Selection.ClearContents
End Sub
================================================== ======


But:
I 'd like to launch a web page from macro-code without using a sheet as
support .

Thanks! Gill