View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
MikeW[_2_] MikeW[_2_] is offline
external usenet poster
 
Posts: 4
Default 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?
.