Creating Hyperlink in excel 2003 VBA

[sweet_dreams]

Hi all,

I was trying to create hyperlink to other sheet in excel I did it like
that:

Sheets("Index").Activate
Range("a2").Hyperlinks.Add Range("a2"), "", "Control list", , "List"

where "Control List" is the name of sheet I am trying to open

but it doesn't work.

Can U tell me what's wrong???

regards,
sweet_dreams

[davesexcel]

=HYPERLINK("#Sheet3!A1","Sheet2!A1") this takes you to Sheet3 A1 and will label where you are going
=HYPERLINK("#Sheet3!A1",A2) this will take you to sheet 3 A1 but the cell will have the value of A2 of whatever sheet you have this formula in

I will Add that this is a formula in the spreadsheets not a VBA code

[Ardus Petus]

Sub test()
With Sheets("Index")
.Hyperlinks.Add _
Anchor:=.Range("A2"), _
Address:="", _
SubAddress:="'Control list'!A2", _
TextToDisplay:="List"
End With
End Sub

HTH
--
AP

"sweet_dreams" <[email protected]> a écrit dans le message de
news:[email protected]...
> Hi all,
>
> I was trying to create hyperlink to other sheet in excel I did it like
> that:
>
> Sheets("Index").Activate
> Range("a2").Hyperlinks.Add Range("a2"), "", "Control list", , "List"
>
> where "Control List" is the name of sheet I am trying to open
>
> but it doesn't work.
>
> Can U tell me what's wrong???
>
> regards,
> sweet_dreams
>