Thread: Pivot Items
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Pedro Pedro is offline
external usenet poster
 
Posts: 25
Default Pivot Items

Hi
I would like to know what code should I write to hide all the PivotItems a
PivotField might have instead of writing a line of code for each PivotItem
like this:
Worksheets("sheet3").PivotTables(1) _
.PivotFields("year").PivotItems("1998").Visible = False

Regards,
Pedro