共用方式為

TreeviewControl Object (Excel)

  • 發行項

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

Remarks

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

Example

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

請參閱

概念

TreeviewControl Object Members

Excel Object Model Reference