Select chart object in Excel 2007
 

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

Select chart object in Excel 2007
 

activesheet.ChartObjects(1).Select

--
Regards,
Tom Ogilvy


"Luca Brasi" wrote:

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

Select chart object in Excel 2007
 

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.

Tom Ogilvy wrote:
activesheet.ChartObjects(1).Select

Select chart object in Excel 2007
 

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.

--
Regards,
Tom Ogilvy


"Luca Brasi" wrote:

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.

Tom Ogilvy wrote:
activesheet.ChartObjects(1).Select

Select chart object in Excel 2007
 

Tom, great! works!
Many thanks


Tom Ogilvy wrote:
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.