Creating a PivotTable with VBA
 

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

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

Creating a PivotTable with VBA
 

It made the trick.
Thanks

"MIKE215" wrote:

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