View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
MikeC MikeC is offline
external usenet poster
 
Posts: 16
Default 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!