Hi there!

I have to creat links for some charts on the bottom of my worksheet. Since
charts are not assigned to a cell, I've searched some forums but nothing
worked.
Can anyone help me?
I've got macros on my workbook to open the file on the same worksheet. No
macros on any worksheet individually.

Here're my 3 findings and the instructions i followed for the fist link. For
the other links I guess I just need to add more IF's or buttons:



============1============

Create a Hyperlink to cell A1 on the same sheet (you can change the text to
display to make it meaningful). Right click the sheet tab and choose View
Code. Paste this into the window on the right:

code:
--------------------------------------------------------------------------------

Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)
If Right(Target.Name, 2) = "A1" Then
Sheets("Chart1").Activate
End If
End Sub

--------------------------------------------------------------------------------

Change the reference to Chart1 to suit. Press Alt+F11 to return to your
worksheet, and try it out.



============2============

code:
--------------------------------------------------------------------------------

Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)
If Target.Name = "Sheet2!A1" Then
ActiveSheet.ChartObjects("Chart 1").Activate
End If
End Sub



============3============

It's probably easier to add a button off the control toolbox and edit its
code to the following (change Chart1 to whatever your chart sheet is called)

Private Sub CommandButton1_Click()
ActiveWorkbook.Sheets("Chart1").Select
End Sub



HOPE TO GET YOUR HELP

Bruno