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

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

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" wrote in message
...
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

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

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" wrote in message
...
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

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

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" wrote in message
...
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" wrote in message
...
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

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

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" wrote in message
...
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" wrote in message
...
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