Big_Belly_Bob
New Member
- Joined
- Feb 9, 2006
- Messages
- 27
Hi, Sorry if this question has been asked before but I've tried Google and the forum search and not been able to get a satisfactory answer.
I'm looking for the VB code to launch the pivot table wizard but when I say "the pivot table wizard" I'm talking about the dialog that pops up when you click Insert>PivotTable in 2007 & 2010 which is not the same as the wizard that you get when doing Alt+D P or when inserting a pivot table in older versions of excel.
I'm essentially after the code that will produce the exact same action as when you click the pivot table button so that I can then add a piece of code that that will change the default settings of the pivot table as soon as it has been created using something like:
PivotTables.RowAxisLayout xlTabularRow
PivotCache.MissingItemsLimit = xlMissingItemsNone
I'm looking for the VB code to launch the pivot table wizard but when I say "the pivot table wizard" I'm talking about the dialog that pops up when you click Insert>PivotTable in 2007 & 2010 which is not the same as the wizard that you get when doing Alt+D P or when inserting a pivot table in older versions of excel.
I'm essentially after the code that will produce the exact same action as when you click the pivot table button so that I can then add a piece of code that that will change the default settings of the pivot table as soon as it has been created using something like:
PivotTables.RowAxisLayout xlTabularRow
PivotCache.MissingItemsLimit = xlMissingItemsNone
