| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Suppress PopUp
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 -- Shell |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Suppress PopUp
try this:
Application.DisplayAlerts = False ....your table refresh code Application.DisplayAlerts = True Untested with a pivot table, so your mileage may vary... "Shell" wrote: 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 -- Shell |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Suppress PopUp
This does NOT work
-- Shell "JLatham" wrote: try this: Application.DisplayAlerts = False ...your table refresh code Application.DisplayAlerts = True Untested with a pivot table, so your mileage may vary... "Shell" wrote: 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 -- Shell |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Suppress PopUp
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 "Shell" wrote: This does NOT work -- Shell "JLatham" wrote: try this: Application.DisplayAlerts = False ...your table refresh code Application.DisplayAlerts = True Untested with a pivot table, so your mileage may vary... "Shell" wrote: 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 -- Shell |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Suppress PopUp
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 "Shell" wrote: This does NOT work -- Shell "JLatham" wrote: try this: Application.DisplayAlerts = False ...your table refresh code Application.DisplayAlerts = True Untested with a pivot table, so your mileage may vary... "Shell" wrote: 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 -- Shell |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Suppress @VALUE! on a template. | Excel Discussion (Misc queries) | |||
| Suppress a row | Excel Worksheet Functions | |||
| Suppress popup "Do you really want to save..." after open and immediate close of excel sheets ? | Excel Discussion (Misc queries) | |||
| Suppress popup "Do you really want to save..." after open and immediate close of excel sheets ? | Excel Worksheet Functions | |||
| "Why did we get here????" popup | Excel Discussion (Misc queries) | |||
Hybrid Mode
