Put the following before the message box:

Application.DisplayAlerts = False

and after the message box:

Application.DisplayAlerts = True

This will choose the default answer for the message box, so make sure
you are setting the default button appropriately.

--JP


On Oct 5, 12:37*pm, mmiazga wrote:
I have a macro which takes 15 min. to run. *At various times while the macro
is running a popup box will appear and ask "A file named k:\abc.prn already
exits at this location. Do you want to replace it?" Yes No Cancel then
another one pops up "Do you want to save the changes......" Yes No Cancel.. *I
have 15 various pop ups which appear. *My answers will always be the same for
each pop up but how do I automate it so it always answers the questions for
me and I don't have to sit and wait to answer each question as they pop up?