Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Pls check if it helps.Will be expecting your feedback.
------------------------------------------------------------- Just ensure that you select one cell in PivotTable. ------------------------------------------------------------ Sub SDPivotCustomize() Dim PT As PivotTable, PC As PivotCell, PF As PivotField Application.ScreenUpdating = True Set PC = ActiveCell.PivotCell Set PT = PC.PivotTable For Each PF In PT.PivotFields PF.Subtotals = Array(False, False, _ False, False, False, False, False, _ False, False, False, False, False) Next PF PT.RowAxisLayout xlTabularRow Application.ScreenUpdating = False End Sub -------------------------------------------------------------------- Not tried to optimize because much benefit will not be available. --------------------------------------------------------------------- |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do you view an active macro code? | Excel Discussion (Misc queries) | |||
omit dialog box display during pivot table refresh (macro) | Excel Programming | |||
Pivot Table Macro - How to describe the Active range (so that themacro can be used on new sets of data) | Excel Programming | |||
Set Pivot Table Tabular Form to Default | Excel Discussion (Misc queries) | |||
Macro (or equivalent) to display certain pivot table data | Excel Discussion (Misc queries) |