Home |
Search |
Today's Posts |
#6
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
I have no idea where that other code comes from. It doesn't look like any
autosave routine to me. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Tom" wrote in message ... 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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
VBA: Where to find Excel Object model? | Excel Discussion (Misc queries) | |||
Chart Wizard "as object in:" turned off | Excel Discussion (Misc queries) | |||
Problem with xlusrgal.xls file | Charts and Charting in Excel | |||
pivot table multi line chart | Charts and Charting in Excel | |||
Can't save chart as object in current sheet | Charts and Charting in Excel |