PivotField.AutoShowType Property

Syntax

expression.AutoShowType

expression A variable that represents a PivotField object.

Example

This example displays a message box showing the AutoShow parameters for the Salesman field.

Visual Basic for Applications

Visual Basic for Applications
`With Worksheets(1).PivotTables(1).PivotFields("salesman") If .AutoShowType = xlAutomatic Then r = .AutoShowRange If r = xlTop Then rn = "top" Else rn = "bottom" End If MsgBox "PivotTable report is showing " & rn & " " & _ .AutoShowCount & " items in " & .Name & _ " field by " & .AutoShowField Else MsgBox "PivotTable report is not using AutoShow for this field" End If End With`

With Worksheets(1).PivotTables(1).PivotFields("salesman") If .AutoShowType = xlAutomatic Then r = .AutoShowRange If r = xlTop Then rn = "top" Else rn = "bottom" End If MsgBox "PivotTable report is showing " & rn & " " & _ .AutoShowCount & " items in " & .Name & _ " field by " & .AutoShowField Else MsgBox "PivotTable report is not using AutoShow for this field" End If End With

auto show type Auto Show Type Property AutoShowType AutoShowType Property Disable pivottable autoshow? Turn on autoshow?

Returns xlAutomatic if AutoShow is enabled for the specified PivotTable field; returns xlManual if AutoShow is disabled. Read-only Long.

See also: