blairacuda
Technical User
Hello All,
I have a PivotTable that is not allowing me to hides its PivotFields.
Here is my code for the hide:
For Each Pf In Pt.PivotFields
temp = Pf.Name
If temp = "Description" Then
Pf.Hidden = True
End If
Next
When the hidden flag attempts to change I get: Run-time error '1004': Application-defined or object-defined error.
Can someone help to lead me in the right direction? I am new to Pivots and for some reason this just is not working for me.
Thanks in advance.
CBlair
Crystal, InstallShield, branching out in other programming realms.
I have a PivotTable that is not allowing me to hides its PivotFields.
Here is my code for the hide:
For Each Pf In Pt.PivotFields
temp = Pf.Name
If temp = "Description" Then
Pf.Hidden = True
End If
Next
When the hidden flag attempts to change I get: Run-time error '1004': Application-defined or object-defined error.
Can someone help to lead me in the right direction? I am new to Pivots and for some reason this just is not working for me.
Thanks in advance.
CBlair
Crystal, InstallShield, branching out in other programming realms.