View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
TheVisionThing TheVisionThing is offline
external usenet poster
 
Posts: 22
Default Format Page Field

I'm looking for some code as follows to change the background color of every
page field in a pivot table

Dim pt as PivotTable,pf as PivotField
For Each ws In ThisWorkbook.Worksheets
For Each pf In pt.PageFields
' change the background color
Next
Next

Thanks,
Wayne C.