Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2007 Chart-Objects don't work properly
Hi,
I hope someone is able to help me. I just switched from Excel 2003 to Excel 2007. In Version 2003 I made a kind of graphical analysis feature where I use excel-charts embedded into a worksheet. Hereby I use chart-events to influence my charts. Now I've got some problems which I didn't have in Excel 2003. 1. I noticed that there are several properties within the chart object model which I cannot use when I set up object variables. For example: this code will not work (run-time error): Dim xlChartObject As Excel.ChartObject Set xlChartObject = ActiveSheet.ChartObjects("Diagramm 1") xlChartObject.ProtectChartObject = True But this code works: Dim xlChartObject As Excel.ChartObject Set xlChartObject = ActiveSheet.ChartObjects("Diagramm 1") ActiveSheet.ChartObjects(xlChartObject.Index).Prot ectChartObject = True Why is this so? I noticed this behaviour with several properties. 2. The second problem I have concerns chart events. In Excel 2003 I locked the worksheet and I still could catch chart events of embedded charts. But if I lock the worksheet in Excel 2007 then I can no longer catch any chart events. Please help me with these points. Best regards, Lars |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Line Chart from office 2003.xls not formatted properly in 2007 | Excel Discussion (Misc queries) | |||
2003 Chart not displaying properly in 2007 | Charts and Charting in Excel | |||
Can not insert chart in Excel 2007? Chart does not work right? | Excel Discussion (Misc queries) | |||
Cleanup worksheets from 97-2003 to work properly on Excel 2007 | Excel Worksheet Functions | |||
Sorting in an Excel Chart won't work properly | Excel Discussion (Misc queries) |