TableStyle Members (Excel)

GitHub-Mark-64px

Contribute to this content

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

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

Name

Description

Delete

Deletes the TableStyle object.

Duplicate

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

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.

ShowAsAvailableTimelineStyle

Returns or sets whether the specified table style is shown as available in the timeline styles gallery. Boolean. Read/write

TableStyleElements

Returns the TableStyleElements object. Read-only.

Show: