Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel VSTO pivot table code revision help needed...
Hello,
The first line below works cleanly in my project, but I am having errors/issues with the next two lines. Globals.Sheet16.PivotTables("PivotTable2").PivotCa che.Refresh() Globals.Sheet16.PivotTables("PivotTable2").PivotFi elds("fy").Item(1).Visibl* e = True Globals.Sheet16.PivotTables("PivotTable2").PivotFi elds("fy").Item(2).Visibl* e = False Please advise as to what is needed to revise the code to get it to work as expected. Thanks, Kevin |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel VSTO pivot table code revision help needed...
..PivotFields(1).PivotItems(2).Visibl*e = False |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel VSTO pivot table code revision help needed...
Herbert,
Thanks, it worked as I had hoped! Thanks, Kevin --- frmsrcurl: http://msgroups.net/microsoft.public...on-help-needed |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel VSTO pivot table code revision help needed...
Herbert,
Thanks, it worked as I had hoped! Thanks, Kevin On Feb 28, 12:42*pm, Herbert Seidenberg wrote: .PivotFields(1).PivotItems(2).Visibl*e = False |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table dynamic range code needed | Excel Programming | |||
Excel Pivot Table VB Code | Excel Discussion (Misc queries) | |||
Macro Revision needed | Excel Programming | |||
Get VSTO code to run on every launch of Excel | Excel Programming | |||
Pivot table help needed | Excel Programming |