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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
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
 
Back
Top