TableStyle.ShowAsAvailablePivotTableStyle Property
Sets or returns if a style is shown in the gallery for PivotTable styles or not. Read/write.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
Syntax
'Declaration
Property ShowAsAvailablePivotTableStyle As Boolean
Get
Set
'Usage
Dim instance As TableStyle
Dim value As Boolean
value = instance.ShowAsAvailablePivotTableStyle
instance.ShowAsAvailablePivotTableStyle = value
bool ShowAsAvailablePivotTableStyle { get; set; }
Property Value
Type: System.Boolean
Boolean
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.