Automatically Hide Pivot Table Field List Box

G

Guest

After running a pivot table in Excel 2003 the pivot table field list box
automatically appears. Can I change settings so this box does not
automatically appear?
 
G

Guest

if you are using excel 2000+, put below code in sheet's module .

Private Sub Worksheet_PivotTableUpdate(ByVal Target As PivotTable)
Application.ScreenUpdating = False
ActiveWorkbook.ShowPivotTableFieldList = False
Application.ScreenUpdating = True
End Sub


Regards,

Shailesh Shah
http://in.geocities.com/shahshaileshs/
(Excel Add-ins Page)
 

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

Question on the occupied field of the pivot table in excel spreadsheet 0
Pivot table filter list - listing irrelevant subcategorys 1
Pivot Table Missing Field List 7
Combo Box / Hard Coded List 1
Pivot Table Page Change Code 1
Can't open pivot table field list 1
Pivot Table - Changes 5
Problem inserting calculated pivot fields into Pivot Table (2007) 1

Top