I have many embedded objects in PowerPoint 2007 that contain a chart and a data sheet.
I need to dynamically change the label and tick mark spacing
This will run, but it doesn't change the values to 316 (I'll be using a variable later).
Do I need to activate the axes or the chart itself?
Any help would be great.
Thanks ahead of time



If oSh.Type = msoEmbeddedOLEObject Then
oSh.OLEFormat.Activate
With oSh.OLEFormat.Object
.ActiveChart.Axes(xlCategory).Select
.ActiveChart.Axes(xlCategory).TickMarkSpacing = 316
.ActiveChart.Axes(xlCategory).TickLabelSpacing = 316
End With
End If