Edit

Share via

TableStyle.ShowAsAvailablePivotTableStyle property (Excel)

  • Article

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

Syntax

expression.ShowAsAvailablePivotTableStyle

expression A variable that represents a TableStyle object.

Remarks

The property returns True if the style is shown in the gallery for PivotTable styles.

Note

Users can set the ShowAsAvailableTableStyle or ShowAsAvailablePivotTableStyle properties to False even when the style is already applied to a table or PivotTable. In this case, the gallery will not show the style, and no style is shown as selected when the active cell is in the table or the PivotTable.

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.