Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
2007 Bug? ChartTitle.Characters.Text not working
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
2007 Bug? ChartTitle.Characters.Text not working
Yes - and the good news is that works all the way back to Office 97. However,
if this isn't a bug or isn't fixed in 2007, I expect to see a lot of Office code breaking - this is a common statement if you google it. " wrote: I took ".Characters." out and it seemed to work for chart and axes titles. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How many characters in text box in Excel 2007? | Excel Discussion (Misc queries) | |||
Excel 2007: get formula from charttitle | Charts and Charting in Excel | |||
Working Excel 2007 pivot table, want just text to show on the pivo | Excel Discussion (Misc queries) | |||
Text to Columns not working correctly with dates in Excel 2007 | Excel Discussion (Misc queries) | |||
VBA: Can't set ChartTitle.Text?? | Charts and Charting in Excel |