Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ShowDetail on PivotTable does not work in VBA
I need to programmatically hide the details of one of my row fields in a
pivot table. Manually, you would select the field and click on the Hide details icon (the yellow minus sign) in the pivot table toolbar. Programmatically, I thought I needed to set the ShowDetails property of the pivot item to False: objSheet.Range("H6").ShowDetails = False But that doesn't work, apparently, ShowDetails is not a property of the Range object. But, when I use the Excel recorder to create a macro for this I get the following: Range("G6").Select Selection.ShowDetail = False I tried using the Selection object and I still get the same error. Note that I'm running the code from within MS Access, and I reference the Excel object library. Thanks in advance, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VB Help If Statement in Selection.ShowDetail = True | Excel Programming | |||
Cannot copy PivotTable to Network, at work. | Excel Discussion (Misc queries) | |||
ShowDetail on PivotField rather than PivotItem?? | Excel Programming | |||
PivotTable: ChildItems and ParentItem don't work | Excel Programming | |||
VBA / Pivottable / showdetail - problem | Excel Programming |