Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
2 fonts in Chart title in E2007
We are tranferring code from 2003 to 2007 and noticed a change in how VBA
reads the following line: ActiveChart.ChartTitle.Characters(5,2).Font.Color = vbred IN 2003, it reads it correctly coloring letters 5 & 6 red. in 2007, it colors the whole Chart title red. It seems that regardless of the start and length I pass into the characters function, the formatting occurs to the entire chart title, not just the characters I wanted. Even recording the VBA in 2007 yields no help as it cannot record the partial font change, even though the GUI allows it. IN 2003 you can record the partial font change. Any ideas on what's happening here? -- ********************* J Streger MS Office Master 2000 ed. MS Project White Belt 2003 User of MS Office 2003 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to hide a chart title, but keep the title in the chart | Charts and Charting in Excel | |||
Extracting chart title from Embedded Excel Chart in PowerPoint | Excel Programming | |||
Changing File Title Fonts | Excel Discussion (Misc queries) | |||
2 different fonts in chart title? | Excel Programming | |||
Pasting Objects into Chart title and Axis title | Charts and Charting in Excel |