TreeviewControl Object [Excel 2003 VBA Language Reference]

  • Article

Represents the hierarchical member-selection control of a cube field. You use this object primarily for macro recording; it is not intended for any other use.

Using the TreeviewControl Object

Use the TreeviewControl property to return the TreeviewControl object. The following example sets the control to its "drilled" (expanded, or visible) status for the states of California and Maryland in the second PivotTable report on the active worksheet.

ActiveSheet.PivotTables("PivotTable2") _
    .CubeFields(1).TreeviewControl.Drilled = _
        Array(Array("", ""), _
        Array("[state].[states].[CA]", _
            "[state].[states].[MD]"))

Properties | Application Property | Creator Property | Drilled Property | Hidden Property | Parent Property

Parent Objects | CubeField Object

Child Objects