Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating PivotTable in Excel2007 | Excel Discussion (Misc queries) | |||
Problem with creating pivottable | Excel Discussion (Misc queries) | |||
Creating a PivotTable w/o selecting data in an existing PivotTable | Excel Discussion (Misc queries) | |||
what is wrong with creating pivottable ? | Excel Programming | |||
Creating a PivotTable in a Different Workbook | Excel Programming |