Hiding Pivot Table Wizard
 

Have you tried setting the Enabled property if the toolbar to false? This
is a a permanent change, so you will need to turn it back on later.

Bob Flanagan
Macro Systems
144 Dewberry Drive
Hockessin, Delaware, U.S. 19707

Phone: 302-234-9857, cell 302-584-1771
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel

"MikeC" wrote in message
...
a am adding date to an excel spreadsheet from a VB application and then
calling a macro which includes a pivot table. When the process is
complete,
the data is displayed correctly. However, the Pivot Table Wizard is
displayed on top of the worksheet.

Does anyone know of a way to shutdown or at least hide the Pivot Table
Wizard within VBA code?

Thanks in advance!

Hiding Pivot Table Wizard
 

a am adding date to an excel spreadsheet from a VB application and then
calling a macro which includes a pivot table. When the process is complete,
the data is displayed correctly. However, the Pivot Table Wizard is
displayed on top of the worksheet.

Does anyone know of a way to shutdown or at least hide the Pivot Table
Wizard within VBA code?

Thanks in advance!

Hiding Pivot Table Wizard
 

Bob

Setting the enable property of the toolbar did not accomplish what I wanted.
However, setting the visible property of the toolbar to false did accomplish
what I wanted.

The actual code is:

Application.CommandBars("PivotTable").Visible = False

You pointed me in the right direction.

Thank You

MIkeC

"Bob Flanagan" wrote:

Have you tried setting the Enabled property if the toolbar to false? This
is a a permanent change, so you will need to turn it back on later.

Bob Flanagan
Macro Systems
144 Dewberry Drive
Hockessin, Delaware, U.S. 19707

Phone: 302-234-9857, cell 302-584-1771
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel

"MikeC" wrote in message
...
a am adding date to an excel spreadsheet from a VB application and then
calling a macro which includes a pivot table. When the process is
complete,
the data is displayed correctly. However, the Pivot Table Wizard is
displayed on top of the worksheet.

Does anyone know of a way to shutdown or at least hide the Pivot Table
Wizard within VBA code?

Thanks in advance!