Creating a PivotTable with VBA
Hi Enrico,
try this
Application.screenupdating = false
your code
Application.CommandBars("PivotTable").Visible = False
Application.screenupdating = true
Mike
"Enrico Campidoglio" wrote:
Hi!
I noticed that when creating a PivotTable with the PivotTableWizard method
the PivotTable Command Bar is automatically displayed on the worksheet.
Is there a way to change this behaviour? Or is it necessary to manually hide
the command bar?
Thanks in advance
/Enrico
|