AutoMargins Property

True if Microsoft Excel automatically calculates text frame margins. Read/write Boolean.

Remarks

When this property is True, the MarginLeft, MarginRight, MarginTop, and MaginBottom properties are ignored.

Example

This example causes Microsoft Excel to automatically calculate text frame margins for text in shape one.

Worksheets(1).Shapes(1).TextFrame.AutoMargins = True