View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bruce Bowler Bruce Bowler is offline
external usenet poster
 
Posts: 30
Default avoiding dialog boxes in macros

I have a script that I'm working on that, among other things may try and
write a file that already exist. Currently, it pops up a dialog box and
stalls the process. I'd like to not have the dialog boxes come up, but
rather simply overwrite the file. What option(s) do I need to specify to
accomplish that goal?

Bruce

--
+-------------------+---------------------------------------------------+
Bruce Bowler | When your illusions are gone you have ceased to
1.207.633.9600 | live. - Anonymous
|
+-------------------+---------------------------------------------------+