Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA / Pivottable / showdetail - problem
Hi, I have created VBA code to create a pivot table from data located in a Excel sheet. The pivot table comes out beautifully. The problem is whe the code attempts to modify the table. I have 'months' selected as a column field. The problem is that I d not want the separate month columns to be visible. Only the colum totals. This way the users can select which ever months they want to se ("cumulative" figures) in the column totals. I can hide details for the month field manually. And it works just fin after that. When I turned the macro recorder on when doing this manua hiding the code created was (modified to show only the property): ...PivotTables("BudgetPivot").PivotFields("Month") .PivotItems("Sep").ShowDetai = False When I inserted this code (actually a line for each month) to my pivo table creation code and tested it what happened was that these line had no effect at all. They did not cause any errors, nor they did th task mentioned. Can anyone help me in finding a way to hide the monthcolumns? Thank you in advcance! Marko = -- sihvonm ----------------------------------------------------------------------- sihvonma's Profile: http://www.excelforum.com/member.php...fo&userid=1651 View this thread: http://www.excelforum.com/showthread.php?threadid=31367 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivottable code problem | Excel Discussion (Misc queries) | |||
problem with pivotTable in Excel | Excel Discussion (Misc queries) | |||
Embedded Chart Versus Chart - ShowDetail Issue | Charts and Charting in Excel | |||
Pivottable Problem | Charts and Charting in Excel | |||
Excel PivotTable C# problem | Excel Programming |