Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
TreeviewControl Object (Excel)
Collapse the table of content
Expand the table of content

TreeviewControl Object (Excel)

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.

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]")) 

Show:
© 2015 Microsoft