method FormatAppearances.Remove (Key as Variant)
Removes a specific member from the collection.

TypeDescription
Key as Variant A String expression that indicates the Key of the FormatAppearance object to be removed.
The Remove method removes a FormatAppearance object giving its key. The Clear method removes all elements in the FormatAppearances collection. Excludes the exPivotBarAllowFormatAppearance flag from the PivotBarVisible property, and so no FormatAppearance objects are displayed on the control's context menu. Use the Add method to add a new FormatAppearance object. You can use the for each statement to enumerate all objects in the FormatAppearances collection.