VB help! - Run-time error ‘438’: Object doesn’t support this property or method.

[FiservEFTSalesOps]

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>

 

[iliace]

ShowDetail method was added in Excel 2007. It's not available in earlier versions.

 

[FiservEFTSalesOps]

Thanks, I really appreciate the response.

So there's no way to automate via a button/macro showing and hiding the detail in a 2003 pivot table other than the menus? I have a user-base that's pivot illiterate and I'm trying to make it easy fro them to navigate.

Any suggestions?

 

[iliace]

I think you would have to use the ShowDetail of the Range class to accomplish the same result. PivotSelect method will return a Range object.