View Single Post
  #2   Report Post  
Tushar Mehta
 
Posts: n/a
Default

Trapping the error if Activechart doesn't yield anything is the
quickest way to do it. You could, of course, start with the selection
and loop to check if it is a chart (chartobject?) or a workbook and if
not move to the parent. If you get to a workbook or the application,
the selected object is not a chart or a component of one.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article .com,
says...
Is there any way (property) to determine if an embedded chart on a
sheet is selected or if it exists? Or is the best way to try access
the ActiveChart and catch the error. We have to make sure that the
ActiveChart, if it exists, is Deselected before performing a certain
operation and we only want to Deselect it if it is, in fact, selected.
Any info this would be appreaciated. Thanks.

Roy