Classic PivotTable Layout

  • Thread starter Thread starter Kirk P.
  • Start date Start date
K

Kirk P.

I wish there was a default setting to force pivot tables to use the "classic"
layout, but failing that, I'm looking to create a macro that runs whenever a
pivot table is created. I've got this code that works, but only within the
current workbook. How do you get Excel to automatically recognize when a
pivot table is being created to change the layout to classic?

With ActiveSheet.PivotTables("PivotTable1")
.InGridDropZones = True
.RowAxisLayout xlTabularRow
End With
 
So you are looking for an event that fires when a pivot table is created.
That is a bit of a problem as there is no event specific to that. There is
one that fires on update that executes when a table is created. It however
also runs on each update. If you use that event it will change to Classic
look at each update which probably does not work for you but that is up to
you.

Here is a link to App level events...
http://www.cpearson.com/excel/AppEvent.aspx
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Table Macro 1
VBA Pivot Table Error 1
Format Pivot total rows 2
Code problems for pivot table 1
syntax in VBA to create a pivot table 2
Macro to update pivot table data range 3
Using macro to switch 'page' in a pivot table? 1
Refresh data with macro code 0

Back
Top