On Jan 16, 5:34*pm, "Wolfgang Gary" wrote:
I setup a pivot table programmatic.

But how can I hide the most right total row?
I have found a checkbox "Totals for rows / columns" in the TableOptions
Dialog.
But how to set this per programm?

Many thanks for any hint.
Wolfgang

are you talking about the "Grand totals for rows" and "Grand totals
for columns" checkboxes in the pivot table options? if so, the code
would be:

'change "PivotTable1" to the correct Pivot Table name(s)
With ActiveSheet.PivotTables("PivotTable1")
.ColumnGrand = False
.RowGrand = False
End With