vba courses london - Pivot Tables

Hi Christopher,
Yes, as I suggested, it turns out to be a settable property of a PivotTable object:

PivotTable.EnableDrilldown

e.g.

Sub ToggleDrilldown()

Dim pt As PivotTable
Dim status As Boolean

Set pt = Worksheets("PT Orders").PivotTables("PT_Orders")
status = pt.EnableDrilldown
pt.EnableDrilldown = Not (status)

End Sub

PivotTable has lots of properties! Might be worth a browse through the others.

/Roy