creating hyperlink in excel vba

Hi all,

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

VB Code:

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

but it doesn't work.

Can U tell me what's wrong???

regards,
sweet_dreams

If its supposed to point to another workbook then you need to include the ful path.

Record a macro doing your task and it will show you exactly how. ;)