| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Table Wizard in 2007 | Excel Discussion (Misc queries) | |||
| Pivot Table Wizard causes crash | Excel Worksheet Functions | |||
| excel 2007 pivot table wizard | Excel Worksheet Functions | |||
| Pivot Table Wizard Error (Expected 52) | Excel Discussion (Misc queries) | |||
| How to view VB Code behind Pivot Table created via Wizard | Excel Programming | |||
Linear Mode
