Automatically Hide Pivot Table Field List Box

R

RB

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?
 
S

Shailesh Shah

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)
 
Top