Thread: disable pop up when overwrithing saved files
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
  
Posts: 11,123
Default disable pop up when overwrithing saved files
Use

Application.DisplayAlerts = False
' your save code
Application.DisplayAlerts = True


--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"Beth" wrote in message ...
How do I incooperate code that will automatically save an
existing file and not prompt me with the pop up window
of 'A file named Invoice Report already exists in this
locatin. Do you want to replace it?.


Reply With QuoteReply With Quote