Hiding Pivot Table Wizard

B

Bob Flanagan

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
 
M

MikeC

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!
 
M

MikeC

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top