Suppress PopUp

[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

 

[JLatham]

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

Untested with a pivot table, so your mileage may vary...

 

[Shell]

This does NOT work
--
Shell

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

Untested with a pivot table, so your mileage may vary...

 

[Rik_UK]

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

 

[Rik_UK]

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