Open Axis-Dialog

This is not possible with VBA. But you don’t need to open a dialog to copy the properties of the diagram.

Example:
[code]
Dim oDiag1 As Diagram2D
Dim oDiag2 As Diagram2D
‘…
With oDiag2
.YAxes(1).Scaling.StartValue = oDiag1.YAxes(1).Scaling.StartValue
.YAxes(1).Scaling.EndValue = oDiag1.YAxes(1).Scaling.EndValue
‘…
End With
[/code]
support@weisang.com