| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| PivotTable Macro Reverts to Count Function | Excel Worksheet Functions | |||
| How to create a macro that compares a list to another list | New Users to Excel | |||
| How do I refresh a PivotTable and remove outdated page field entr. | Excel Discussion (Misc queries) | |||
| PivotTable Column Field Values | Excel Discussion (Misc queries) | |||
| How can I see a list of macro key assignments in Excel 2002? | Excel Worksheet Functions | |||
Threaded Mode
