So the index 0 points first dimension. My requirement is to always hide the first expression. For this I am trying to write a macro like this. But When the user changes the number selections in Pivot table the width is interchanging to other columns. Please tell me how to tweak this macro so that it always identifies the first expression.
Public Sub hide
Private Sub HideColumn(ch,n)
Set ch = activeDocument.getsheetobject(ch)