Share via


TreeviewControl.Drilled Property

Sets the "drilled" (expanded, or visible) status of the cube field members in the hierarchical member-selection control of a cube field. This property is used primarily for macro recording and isn’t intended for any other use.

Namespace:  Microsoft.Office.Interop.Excel
Assembly:  Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)

Syntax

'Declaration
Property Drilled As Object
    Get
    Set
'Usage
Dim instance As TreeviewControl
Dim value As Object

value = instance.Drilled

instance.Drilled = value
Object Drilled { get; set; }

Property Value

Type: System.Object

Remarks

The Drilled property accepts an array. Each element of the array corresponds to a level of the cube field that has been expanded. The maximum number of elements is the number of levels in the cube field. Each element of the array is an array of type String, containing unique member names that are visible (expanded) at the corresponding level of the control. See the TreeviewControl object’s Hidden property to determine when members are explicitly hidden in an expanded view.

Note

This property does not return an array that represents the drilled status of the cube field members in the hierarchical member-selection control of a cube field.

See Also

Reference

TreeviewControl Interface

TreeviewControl Members

Microsoft.Office.Interop.Excel Namespace