How to change the name of the object Graph 1 in Excel ?

I've done some Macros in VBA in the spanish version and some users with the
Engish version can't use them due to the name of the graphs.
I tried to change the name of the graphs (objects) but i cannot.
Any idea to solve the problem?
Thanks

Hi,

Use something like this to change the name of the active chart object.

Activechart.parent.name = "MyChart"

For the 1st chart object on the sheet you could use the Index to reference
it.

Activesheet.chartobjects(1).Name = "MyChart"

If you still need help it would be useful if you could post the code you
currently use pointing out where it fails.

Cheers
Andy
--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"rir" <rir@discussions.microsoft.com> wrote in message
news:CE65251A-9689-4CEB-AEA6-AFD0F4D6C45D@microsoft.com...
> I've done some Macros in VBA in the spanish version and some users with
> the
> Engish version can't use them due to the name of the graphs.
> I tried to change the name of the graphs (objects) but i cannot.
> Any idea to solve the problem?
> Thanks
>

It didn't work. When I see the incrustated the window Graph it still appears
the old name (Gráfico 1). The macro works but it fails when one person using
the English version of excel because in this version the name is Graph 1
Cheers and thanks

"Andy Pope" wrote:

> Hi,
>
> Use something like this to change the name of the active chart object.
>
> Activechart.parent.name = "MyChart"
>
> For the 1st chart object on the sheet you could use the Index to reference
> it.
>
> Activesheet.chartobjects(1).Name = "MyChart"
>
> If you still need help it would be useful if you could post the code you
> currently use pointing out where it fails.
>
> Cheers
> Andy
> --
>
> Andy Pope, Microsoft MVP - Excel
> http://www.andypope.info
> "rir" <rir@discussions.microsoft.com> wrote in message
> news:CE65251A-9689-4CEB-AEA6-AFD0F4D6C45D@microsoft.com...
> > I've done some Macros in VBA in the spanish version and some users with
> > the
> > Engish version can't use them due to the name of the graphs.
> > I tried to change the name of the graphs (objects) but i cannot.
> > Any idea to solve the problem?
> > Thanks
> >
>

Both of my example code use other ways of referencing the chart object. The
name should not matter.

I agree that code like this would fail if the object was called "Gráfico 1".

Activesheet.chartobjects("Chart 1").name = "MyChart"

Cheers
Andy
--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"rir" <rir@discussions.microsoft.com> wrote in message
news:05C37536-5E88-476D-8814-58A9382426DB@microsoft.com...
> It didn't work. When I see the incrustated the window Graph it still
> appears
> the old name (Gráfico 1). The macro works but it fails when one person
> using
> the English version of excel because in this version the name is Graph 1
> Cheers and thanks
>
> "Andy Pope" wrote:
>
>> Hi,
>>
>> Use something like this to change the name of the active chart object.
>>
>> Activechart.parent.name = "MyChart"
>>
>> For the 1st chart object on the sheet you could use the Index to
>> reference
>> it.
>>
>> Activesheet.chartobjects(1).Name = "MyChart"
>>
>> If you still need help it would be useful if you could post the code you
>> currently use pointing out where it fails.
>>
>> Cheers
>> Andy
>> --
>>
>> Andy Pope, Microsoft MVP - Excel
>> http://www.andypope.info
>> "rir" <rir@discussions.microsoft.com> wrote in message
>> news:CE65251A-9689-4CEB-AEA6-AFD0F4D6C45D@microsoft.com...
>> > I've done some Macros in VBA in the spanish version and some users with
>> > the
>> > Engish version can't use them due to the name of the graphs.
>> > I tried to change the name of the graphs (objects) but i cannot.
>> > Any idea to solve the problem?
>> > Thanks
>> >
>>

You're completely right!
It works
Thanks and cheers!
Ramon

"Andy Pope" wrote:

> Both of my example code use other ways of referencing the chart object. The
> name should not matter.
>
> I agree that code like this would fail if the object was called "Gráfico 1".
>
> Activesheet.chartobjects("Chart 1").name = "MyChart"
>
> Cheers
> Andy
> --
>
> Andy Pope, Microsoft MVP - Excel
> http://www.andypope.info
> "rir" <rir@discussions.microsoft.com> wrote in message
> news:05C37536-5E88-476D-8814-58A9382426DB@microsoft.com...
> > It didn't work. When I see the incrustated the window Graph it still
> > appears
> > the old name (Gráfico 1). The macro works but it fails when one person
> > using
> > the English version of excel because in this version the name is Graph 1
> > Cheers and thanks
> >
> > "Andy Pope" wrote:
> >
> >> Hi,
> >>
> >> Use something like this to change the name of the active chart object.
> >>
> >> Activechart.parent.name = "MyChart"
> >>
> >> For the 1st chart object on the sheet you could use the Index to
> >> reference
> >> it.
> >>
> >> Activesheet.chartobjects(1).Name = "MyChart"
> >>
> >> If you still need help it would be useful if you could post the code you
> >> currently use pointing out where it fails.
> >>
> >> Cheers
> >> Andy
> >> --
> >>
> >> Andy Pope, Microsoft MVP - Excel
> >> http://www.andypope.info
> >> "rir" <rir@discussions.microsoft.com> wrote in message
> >> news:CE65251A-9689-4CEB-AEA6-AFD0F4D6C45D@microsoft.com...
> >> > I've done some Macros in VBA in the spanish version and some users with
> >> > the
> >> > Engish version can't use them due to the name of the graphs.
> >> > I tried to change the name of the graphs (objects) but i cannot.
> >> > Any idea to solve the problem?
> >> > Thanks
> >> >
> >>
>