Select chart object in Excel 2007

  • Thread starter Thread starter Luca Brasi
  • Start date Start date
L

Luca Brasi

Is it possible to select an existing chart object using VBA? The chart
should be selected as if I would have clicked on it manually (thick
border around it). In Excel 2007.
Thanks
 
thanks tom, but this does not select the chart object as if you would
have selected it manually (in Excel 2007). Or does it at your place?? I
have just one Office 2007 installation available for doing some testing.
 
try this instead:

ActiveSheet.ChartObjects(1).Activate
ActiveChart.ChartArea.Select

You can use the name like "Chart 1" instead of the index number in Chart
Objects.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Paste Excel Chart into Existing Powerpoint Chart 1
Multiple chart selection in Excel 2007 8
Selecting a point on a chart in Excel 2007 on Windows 7 7
Axes(xlCategory) for a chart-sheet in 2007 2
Excel 2007 Chart colorindex? 5
Embedded Chart protection 1
Excel 2007 Charts & Memory Leak?? 7
Excel 2010. How to copy chart format to all charts in sheet 2

Back
Top