PDA

View Full Version : [SOLVED] Ignore Message Box in excel



jackdandcoke
10-03-2008, 11:49 AM
So I have a long macro that updates a bunch of pivots, when I refresh a pivot table I get the message

Do you want to replace the contests of the destination cells in Quotes?

Is there a line I can add to my macro that will say yes to all of these messages? It's the only error that's keeping me from having this all automated.

Apps
10-03-2008, 12:01 PM
This may help you ...


Application.DisplayAlerts = False
'###your code goes here
Application.DisplayAlerts = True

jackdandcoke
10-03-2008, 12:07 PM
That was it, thank you!