Thread: Hide Pivottable GrandTotal using VB
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Roger Govier[_3_] Roger Govier[_3_] is offline
external usenet poster
  
Posts: 2,480
Default Hide Pivottable GrandTotal using VB
Hi John

With ActiveSheet.PivotTables("PivotTable1")
.ColumnGrand = False
.RowGrand = False
End With

--
Regards
Roger Govier

"johnb" wrote in message
...
Hi Guys
I'm building a pivottable using ADO and VB and I need to hide the Grand
Totals both for colums and Rows. How do I do that in Code

TIA

johnb

Reply With QuoteReply With Quote