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
Solved! Go to Solution.
I used this
CALL HideColumn("CH02", 3)
PRIVATE SUB HideColumn(ch, n)
SET ch = ActiveDocument.GetSheetObject(ch)
ch.SetPixWidth (n-1), 0
See how the two columns are almost hidden in the below table.... I used two buttons just to show that in the sample app