View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
MIKE215 MIKE215 is offline
external usenet poster
 
Posts: 32
Default 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