Pivot Table Or Pivot Chart

T

tsluu

Does anyone know the vba code to Hide pivotTable fields list window

With Forms.Item("pvtForm").PivotTable.ActiveView
Set fld = .FieldSets("Code")
.RowAxis.InsertFieldSet fld
Set fld = .FieldSets("Desc")
.RowAxis.InsertFieldSet fld
Set fld = .FieldSets("Dept")
.RowAxis.InsertFieldSet fld
Set fld = .FieldSets("Cost")
.DataAxis.InsertFieldSet fld
end with

Also I would like the know the vba code to collapse the "Dept" row so that
it only showed the summary.

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

DAO and Table Locking 6
How to Add Field with Index 7
Pivot Table Question 1
unhide data in pivot table 2
Copy a record into the same table 4
Copy record into same table 1
Access PivotTable Date Filter VBA 0
Please Help!! Error 3111 7

Top