View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Supress SaveAs dialog box?

The code you show does not cause the SaveAs dialog to show. suspect you
have this in the BeforeSave event. If so, you need to add

Cancel = True

--
Regards,
Tom Ogilvy

"Ed" wrote in message
...
I have
Application.DisplayAlerts = False
Application.EnableEvents = False
wb.SaveAs strFName
Application.EnableEvents = True
Application.DisplayAlerts = True

DisplayAlerts suppresses the message that I'm overwriting a file, but will
not keep the SaveAs dialog box from popping up. I'm using XL2000, SP-3.
Any suggestions? Do I have to work through the DIalogs collection and

kill
that one if it comes up?

Ed