Edit

TableStyle.ShowAsAvailableTableStyle property (Excel)

  • Article

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

Syntax

expression.ShowAsAvailableTableStyle

expression A variable that represents a TableStyle object.

Remarks

If True, this style is shown in the gallery for table styles.

You can set this property to False even when the style is already applied to a table. In this case, the gallery will not show the style, and when the active cell is in that table, no style is shown as selected.

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.