ProtectFormatting Property
TOC
Collapse the table of content
Expand the table of content

Chart.ProtectFormatting Property (Excel)

Office 2013 and later
GitHub-Mark-64px

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

True if chart formatting cannot be modified by the user. Read/write Boolean.

expression .ProtectFormatting

expression A variable that represents a Chart object.

This property is not persisted when the file is saved. If you set this property to True and then reopen the file, it will no longer be set to True.

This example protects the formatting of embedded chart one on worksheet one.

Worksheets(1).ChartObjects(1).Chart.ProtectFormatting = True

Concepts

Other resources

Show:
© 2016 Microsoft