TableStyle Members (Excel)

  • Article

Represents a single style that can be applied to a table.

Methods

Name

Description

Delete

Deletes the TableStyle object.

Duplicate

Duplicates the TableStyle object and returns a reference to the new copy.

Properties

Name

Description

Application

When used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. When used with an object qualifier, this property returns an Application object that represents the creator of the specified object. Read-only.

BuiltIn

True if the style is a built-in style. Read-only Boolean.

Creator

Returns a 32-bit integer that indicates the application in which this object was created. Read-only Long.

Name

Returns the name of the object. Read-only String.

NameLocal

Returns or sets the name of the object, in the language of the user. Read-only String.

Parent

Returns the parent object for the specified object. Read-only.

ShowAsAvailablePivotTableStyle

Sets or returns if a style is shown in the gallery for PivotTable styles or not. Read/write Boolean.

ShowAsAvailableSlicerStyle

Returns or sets if the specified table style is shown as available in the slicer styles gallery. Read/write

ShowAsAvailableTableStyle

Returns or sets a table style shown as available in the table styles gallery. Read/write Boolean.

TableStyleElements

Returns the TableStyleElements object. Read-only.