Suppress PopUp

  • Thread starter Thread starter Shell
  • Start date Start date
S

Shell

In Excell 2000, I have successfully refreshed a pivot table via VBA code.
However at the end of the process I get a Microsoft popup.

PivotTable
ImportD... BoxType Success... OPTSta... OPTSta...
DISCO_... Division Prin Years

These are all the fields in the source data. But how do I, in code,
suppress this popup?

Thanks
 
try this:
Application.DisplayAlerts = False
....your table refresh code
Application.DisplayAlerts = True

Untested with a pivot table, so your mileage may vary...
 
This does NOT work
--
Shell


JLatham said:
try this:
Application.DisplayAlerts = False
...your table refresh code
Application.DisplayAlerts = True

Untested with a pivot table, so your mileage may vary...
Click to expand...
 
Can you post the code to help diagnosis?

--
If this is the answer you hoped for please remember to click the yes button
below...

Kind regards

Rik
 
At the end of the macro is the active cell in the pivot table?

If so try selecting a cell in the code that is not part of the pivot table
after the refresh...

--
If this is the answer you hoped for please remember to click the yes button
below...

Kind regards

Rik
 
Back
Top