Hidden Property

Microsoft Excel Visual Basic

True if the rows or columns are hidden. The specified range must span an entire column or row. Read/write Variant.

expression.Hidden

expression    Required. An expression that returns one of the above objects.

ShowHidden property as it applies to the Scenario object.

True if the scenario is hidden. The default value is False. Read/write Boolean.

expression.Hidden

expression    Required. An expression that returns one of the above objects.

ShowHidden property as it applies to the TreeviewControl object.

Returns or sets the hidden status of the cube field members in the hierarchical member selection control of a cube field. Read/write Variant.

expression.Hidden

expression    Required. An expression that returns one of the above objects.

Remarks

Don't confuse this property with the FormulaHidden property.

TreeviewControl object: The Hidden property returns or sets an array. Each element of the array corresponds to a level of the cube field that is hidden. 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 hidden at the corresponding level of the control. See the DrilledDown property of the PivotItem object to determine when members are visible (expanded) in the control.

Example

This example hides column C on Sheet1.

Worksheets("Sheet1").Columns("C").Hidden = True
		

This example hides the second level member [state].[states].[CA].[Covelo] of the first cube field in the first PivotTable report.

ActiveSheet.PivotTables("PivotTable1").CubeFields(1) _
    .TreeviewControl.Hidden = _
        Array(Array(""), Array(""), _
        Array("[state].[states].[CA].[Covelo]"))