Shadows of the Pivottable Field List while macro is running

D

David P

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,
 

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

Change report firlds in pivot tables and charts with one selection 0
automatically run a macro everyday 6
Code problems for pivot table 1
Prompt msg if the worksheet already exits 2
Pivot Refresh Error when calling Excel Macro from VB.NET program 0
Pivot Table Filtering - Macro 3
Macro to run on all files in a folder but exclude sheets with PivotTable, Pivot Charts and Charts 13
The PivotTable field name is not valid (error) 1

Top