AutoMargins Property

Microsoft Excel Visual Basic

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