If you have code that does the thing, you only need code to hide a special pivotfield?

Check http://www.databison.com/pivot-table...able-in-excel/

There you find all code you need for this. I suggest you also pick one of them to create the pivot table instead of macro recorder solution.

Regards