CalloutFormat.AutoLength Property (Excel)
Applies only to callouts whose lines consist of more than one segment (types msoCalloutThree and msoCalloutFour). Read/write MsoTriState .
expression A variable that represents a CalloutFormat object.
|MsoTriState can be one of these MsoTriState constants.|
|msoFalse . The first segment of the callout retains the fixed length specified by the Length property whenever the callout is moved.|
|msoTrue . The first segment of the callout line (the segment attached to the text callout box) is scaled automatically whenever the callout is moved.|
This example toggles between an automatically scaling first segment and one with a fixed length for the callout line for shape one on
myDocument. For the example to work, shape one must be a callout.
Set myDocument = Worksheets(1) With myDocument.Shapes(1).Callout If .AutoLength Then .CustomLength 50 Else .AutomaticLength End If End With