Jon,
When I use the following code:
ActiveChart.Parent.Name = "z"
the
VB editor automatically adds the autosave code:
Application.Goto Reference:="PERSONAL.XLS!renamechart"
Windows("PERSONAL.XLS").Activate
ActiveWindow.WindowState = xlNormal
How can I get it not to save each time I rename a chart
"Jon Peltier" wrote:
Jeff -
I have a web page that describes the whole chart naming process:
http://peltiertech.com/Excel/ChartsH...ameAChart.html
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
Jeff M wrote:
This has got to be simple but I can't find it...
I'm using vba to create several charts as objects (as opposed to on their
own page). I want to refer to them later, so I want to give them meaningful
names - how do I name them something other than the default "Chart 1", "Chart
2" etc?
Thanks!