Thread: Change name on chart

Hi
can anyone help me with this? I have used this code in Excel2003/Windows2000 and it did work

Sub ChangeChartnumber()
'
'Changing number on chart
'
Dim strNamn As String
Dim strNamn1 As String


strNamn = InputBox("Change from?")
strNamn1 = InputBox("Change to")

    ActiveSheet.ChartObjects(strNamn).Name = strNamn1
   
   
End Sub

Now when I try it I get Cannot find property ChartObjects for Worksheet class. I have tried to change to Worksheet("2") and Worksheets("2") still the same. What I have noticed is that in the other sheet I have a reference library Microsoft ActiveX Data Objects 6.0 Library that is missing in the one I am working with. But, the msado15.dll is pointing to 2.8 Library. If that is the reason, where can I find the correct .dll?

Gunilla