View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default Turn Off Alert Before Overwriting Message Box

Try preceding with

Application.DisplayAlerts = False

and set back to True afterwards

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"JR_06062005" wrote in message
...
In a macro I save a workbook which overwrites another. The problem is

every
time the macro is excuted, I get a message box asking if I want to

overwrite
the existing file. Is there a way to turn this message off?

I've tried placing the following in my macro, but it has no effect:
Application.AlertBeforeOverwriting = False