G
Guest
I have a small macro that works in Office 2003 and XP, but generates error
445 (Object doesn't support this action) in 2007. If I replace
ChartTitle.Characters.Text with ChartTitle.Text, then it works.
Here is the snip with that code.
With ActiveChart
.HasTitle = True
.ChartTitle.Characters.Text = "Data"
.Axes(xlCategory, xlPrimary).HasTitle = True
.Axes(xlCategory, xlPrimary).AxisTitle.Characters.Text = "time"
.Axes(xlValue, xlPrimary).HasTitle = True
.Axes(xlValue, xlPrimary).AxisTitle.Characters.Text = "volts"
End With
445 (Object doesn't support this action) in 2007. If I replace
ChartTitle.Characters.Text with ChartTitle.Text, then it works.
Here is the snip with that code.
With ActiveChart
.HasTitle = True
.ChartTitle.Characters.Text = "Data"
.Axes(xlCategory, xlPrimary).HasTitle = True
.Axes(xlCategory, xlPrimary).AxisTitle.Characters.Text = "time"
.Axes(xlValue, xlPrimary).HasTitle = True
.Axes(xlValue, xlPrimary).AxisTitle.Characters.Text = "volts"
End With