| 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 | |||
Hybrid Mode
