SendKeys or another suggestion in excel 97

R

Richard Irwin

I have a macro that refreshes all queries and pivot tables on a
worksheet, but the macro will stop if the pivot table has changes and
wants to know if I want to update pivot table. Is sendkey the best
option or do I have another choice. If sendkeys is the best option how
do I write the code?
 
F

Frank Kabel

Hi Richard
not tested but maybe the line
Application.Displayalerts = False
at the beginning and
Application.Displayalerts = True
at the end of your procedure might help
 
Top