View Single Post
  #1   Report Post  
Hari Prasadh
 
Posts: n/a
Default Activating a Chart object

Hi,

Whats the correct syntax to access (activate) a chart within a chart sheet
in an excel workbook?

I tried

Sheets("Chart1").Chartobjects("Chart 5").activate

Also,

Charts("Chart1").Chartobjects("Chart 5").activate

But both of them gave run-time error.

Basically I want to select a single chart within a chart sheet and change
the Auto-Scale property to False.

(I need to ultimately do this within all Excel Chart OLE's within a PPT, so
my syntaxes actually have the name of the PPT session along with object name
appended to them.)

Regards,
Hari
India