Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
When scripting pivot table in Excel 2003, I am trying to set
enableitemselection to false on a field in the page field area. When the same field is located in a row or column, the code below works fine, but if I try to specify a pagefield, I get a runtime error 1004. Have also tried to use a for loop with just pt.PivotFields, similar to below, but get the same error when a page field is present in the pivot table. Is there some difference in syntax for pagefield? Thanks for any help : ) Code Works, but not with Pagefields: Dim pt As PivotTable Dim pf As PivotField Set pt = ActiveSheet.PivotTables(1) For Each pf In pt.RowFields pf.EnableItemSelection = False Next For Each pf In pt.ColumnFields pf.EnableItemSelection = False Next |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Working Around 240 Character PRN Field Width Limit | Excel Discussion (Misc queries) | |||
Show Field List in Pivot not working | Excel Discussion (Misc queries) | |||
Calculated Field Total formula not working | Excel Worksheet Functions | |||
Cursor doesn't move when page up or page down in Excel 2003 | Excel Discussion (Misc queries) | |||
Convert 20050118 to a working date field | Excel Worksheet Functions |