hinding expressions

[souadouert]

Hello,

I have a pivot table, with 7 expressions the 7th expression is calculated by the 6 other expressions, and I want to hide them how

thank y

[sunny_talwar · Accepted solution]

I used this

SUB Squeeze

  CALL HideColumn("CH02", 3)

END SUB

PRIVATE SUB HideColumn(ch, n)

  SET ch = ActiveDocument.GetSheetObject(ch)

  ch.SetPixWidth (n-1), 0

END SUB

See how the two columns are almost hidden in the below table.... I used two buttons just to show that in the sample app