Shadows of the Pivottable Field List while macro is running
 

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