FiservEFTSalesOps
New Member
- Joined
- Dec 7, 2009
- Messages
- 31
This is probably simple for many of you.....
I need help to understand why this works with Excel 2007 but not Excel 2003.
I have a button on a worksheet that's assigned a macro that shows only the sub-totals of a pivot table. It works fine for me in Excel 2007, but when I send the file (saved as 2003 format) to someone using Excel 2003, they get: Run-time error ‘438’: Object doesn’t support this property or method.
Can anyone help?
"B6" is the 1st column header of the pivot table [month]
Here's the Macro code:
Sub Show_Mo_ST_Only()<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
' Show_Mo_ST_Only Macro<o></o>
' show only the monthly sub-totals and the GT of the pivot table<o></o>
Range("B6").Select<o></o>
ActiveSheet.PivotTables("PivotTable3").PivotFields("Month").ShowDetail = False<o></o>
Range("B5").Select<o></o>
Selection.End(xlToRight).Select<o></o>
Selection.End(xlToRight).Select<o></o>
Selection.End(xlToLeft).Select<o></o>
End Sub<o></o>
I need help to understand why this works with Excel 2007 but not Excel 2003.
I have a button on a worksheet that's assigned a macro that shows only the sub-totals of a pivot table. It works fine for me in Excel 2007, but when I send the file (saved as 2003 format) to someone using Excel 2003, they get: Run-time error ‘438’: Object doesn’t support this property or method.
Can anyone help?
"B6" is the 1st column header of the pivot table [month]
Here's the Macro code:
Sub Show_Mo_ST_Only()<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
' Show_Mo_ST_Only Macro<o></o>
' show only the monthly sub-totals and the GT of the pivot table<o></o>
Range("B6").Select<o></o>
ActiveSheet.PivotTables("PivotTable3").PivotFields("Month").ShowDetail = False<o></o>
Range("B5").Select<o></o>
Selection.End(xlToRight).Select<o></o>
Selection.End(xlToRight).Select<o></o>
Selection.End(xlToLeft).Select<o></o>
End Sub<o></o>