Microsoft KB Archive/930074

From BetaArchive Wiki
Knowledge Base


The shape remains selected when you use VBA code to select other chart elements such as the chart legend or the chart title in Excel 2007

Article ID: 930074

Article Last Modified on 10/15/2007



APPLIES TO

  • Microsoft Office Excel 2007



SYMPTOMS

Consider the following scenario. In Microsoft Office Excel 2007, you insert a shape into an embedded chart. You move the embedded chart to a chart sheet. Then, you select the shape. In this scenario, when you use Microsoft Visual Basic for Applications code to select other chart elements, such as the chart legend or the chart title, the shape remains selected.

Note This issue does not occur if the embedded chart is on a worksheet.


Additional query words: excel2007 excel2k7 excel12 xl2007 xl2k7 xl12 VBA

Keywords: kbtshoot kbmacro kbchart kbprogramming kbautomation kbprb kbvba KB930074