Hi All,

Does any know how you can prevent the Pivot Table Field List and the Pivot
Table Command Bar from popping up during a macro run that creates reports. I
do use the below codes in the macro, but an outline of a shadow box for the 2
displays until the macro finishes.

Application.ScreenUpdating = False
ActiveWorkbook.ShowPivotTableFieldList = False
Application.CommandBars("PivotTable").Visible = False

Thanks,



--
David P