Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
You will need to use a one time Macro to make the column width = 0
Hi sunny;
i added the macro but i dont know how and where i call this macro
Use a button object to use the Macro. This has to be done only one time for each column. After that you can remove the macro and delete the button
sunny i have this issue
What is the issue? Sorry not sure I understand
What is the exact Macro you used? Can you paste it here?
sub Squeeze
call HideColumn("CH121",5)
end sub
'
private sub HideColumn(ch, n)
set ch = ActiveDocument.GetSheetObject(ch)
ch.SetPixWidth (n-1), 0
end sub
Check out the attachment