hide pivot field
 

i want to hide the specific pivot data field of pivot table using macro.

and the current activating sheet is not the pivot table.
in the case, i want to know it.

*** Sent via Developersdex http://www.developersdex.com ***