General Ledger
Active Member
- Joined
- Dec 31, 2007
- Messages
- 460
Dear All,
Is there an event trigger when creating a new PivotTable (PT)?
I want to create a macro that runs every time I creat a PT. The macro will set display settings of the newly created PT such as:
Uncheck "Autofit column width on update"
Check "Classic PivotTable layout"
Set "Report Layout to Tabular"
This macro should run only one time per PT. Not every time a change is made to a PT.
I am using Excel 2010 with Windows 7.
Thanks,
GL
Is there an event trigger when creating a new PivotTable (PT)?
I want to create a macro that runs every time I creat a PT. The macro will set display settings of the newly created PT such as:
Uncheck "Autofit column width on update"
Check "Classic PivotTable layout"
Set "Report Layout to Tabular"
This macro should run only one time per PT. Not every time a change is made to a PT.
I am using Excel 2010 with Windows 7.
Thanks,
GL