TreeviewControl object (Excel)

Represents the hierarchical member-selection control of a cube field.

Remarks

Use this object primarily for macro recording; it is not intended for any other use.

Example

Use the TreeviewControl property of the CubeField object 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
• Creator
• Drilled
• Hidden
• Parent

See also

• Excel Object Model Reference

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.