Creating a PivotTable with VBA

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Hi Enrico,

try this
Application.screenupdating = false
your code
Application.CommandBars("PivotTable").Visible = False
Application.screenupdating = true

Mike
 
It made the trick.
Thanks

MIKE215 said:
Hi Enrico,

try this
Application.screenupdating = false
your code
Application.CommandBars("PivotTable").Visible = False
Application.screenupdating = true

Mike
Click to expand...
 
Back
Top