How to hyperlink a worksheet.

[matheuscfernandes]

Hi,

I have been trying for the longest time to hyperlink a worksheet, where I'm at the first worksheet called Chart 1, and I want to create a link to another worksheet called CA in the same workbook. I would linke for this link to be in a cell, not in macro if possible. If not, then I could use macro.

How could I write an equation where I could link these two together?

I tryed typing in:

1. =hyperlink("CA!", "Test1")
2. =hyperlink("[Workbook1]CA!", "Test1")
3. =hyperlink("[Workbook1.xls]CA!", "Test1")
4. =hyperlink('Chart1'!, "Test1")
5. I also tryied specifying it to a specific cell to each one of thos tryies, by adding A1 after "!"

I don't know what I'm doing wrong. Any help would be greatly appreciated!

 

[Richard Schollar]

Hi

=HYPERLINK("#'Chart1'!A1","Test1")

 

[matheuscfernandes]

Thanks for your quick reply, I appreciate your time.

It still pops up "Reference not Valid".

I do have a Worksheet called CA, and I changed Chart 1 to CA, but it still didn't work.

 

[Richard Schollar]

Is it a worksheet or a chartsheet?

 

[matheuscfernandes]

It's a worksheet.

 

[Richard Schollar]

Is the name of the tab definitely as it appears in the formula? So if "Chart 1" then it would need the space between the Chart and the 1.