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
Bookmarks