| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hide Pivottable GrandTotal using VB
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Hide Pivottable GrandTotal using VB
Hi Roger
Thanks for the reply. Its so simple when you know the syntax. Where do you find syntax? Kind regards johnb "Roger Govier" wrote: 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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Hide Pivottable GrandTotal using VB
Hi John
The easiest way I find, is to record a short macro, then examine what gets created. -- Regards Roger Govier "johnb" wrote in message ... Hi Roger Thanks for the reply. Its so simple when you know the syntax. Where do you find syntax? Kind regards johnb "Roger Govier" wrote: 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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Hide Pivottable GrandTotal using VB
Hi Roger Thanks for the feedback regards johnb "Roger Govier" wrote: Hi John The easiest way I find, is to record a short macro, then examine what gets created. -- Regards Roger Govier "johnb" wrote in message ... Hi Roger Thanks for the reply. Its so simple when you know the syntax. Where do you find syntax? Kind regards johnb "Roger Govier" wrote: 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Does Excel have a @grandtotal function like Lotus 123 | Excel Worksheet Functions | |||
| The hide PivotTable items functionality is gone in my excel 2000 | Charts and Charting in Excel | |||
| Pivot Table - Selecting the GrandTotal Column in VBA xl2003 | Excel Programming | |||
| PivotTable - how do I hide page field when printing | Excel Discussion (Misc queries) | |||
| Hide zero values in a PivotTable report | Excel Discussion (Misc queries) | |||
Linear Mode
