HiddenLevels Property

Microsoft Excel Visual Basic

Show All

HiddenLevels Property

       

Returns or sets the top levels of the specified hierarchy that are hidden. The default value is 0 (zero), indicating that no levels are hidden. Read/write Integer.

Remarks

To set the value of this property to an integer greater than 0, you must first set the value to 0.

Example

This example hides the top two levels of the hierarchy in the second cube field in the first PivotTable report on the active worksheet.

ActiveSheet.PivotTables(1).CubeFields(2).HiddenLevels = 2