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
Bookmarks