Automatically respond to message box appearing within a VBA macro
try this:
insert:
Applictaion.DisplayAlerts = false
at the star of your code then
Application.DisplayAlerts = true
just before the end sub statement
Mike
-----Original Message-----
Within a macro routine I am creating a .prn file and
saving over an exisiting
file. Every morning this macro runs and a prompt appears
asking if I am sure
I want to overwrite the existing file. The user must
click "Ok" in order for
the routine to continue. Is there some syntax in which
the macro will
automatically answer the msg box?
.
|