No, it's not reverse psychology. I'm thinking it's just some bug in Excel, but maybe I'm wrong.
I have 9 charts on a sheet in Excel 07. I gave each one a significant name. I have a macro that selects each chart and does something, using
No issues there, it selects each one fine and does its thing.
But I save it as a 2003 workbook, and try to run the same code with the file open in Excel 2003, and it doesn't recognize all charts as charts. It selects the first 3 charts fine using the code above, but then when it tries to select the 4th, it gives "Unable to get the ChartObjects property of the Worksheet class".
However, in the immediate window, when I type Print ActiveSheet.ChartObjects.Count I get 9, which is correct.
If I do the following code to try to select all charts, it only selects the first 3 charts:
Dim myChart as ChartObject
For Each myChart In Sheets("Sheet1").ChartObjects
myChart.Activate
Next myChart
So even though I have renamed the charts in 07, and the same names show in 03, is there another place that it is keeping the original chart name possibly? Obviously, I'm very perplexed about this!