View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Daniel75 Daniel75 is offline
external usenet poster
 
Posts: 2
Default Automatically respond to message box appearing within a VBA macro

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?