Thread: dont confirm save with yes/no/cancell
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
  
Posts: 6,953
Default dont confirm save with yes/no/cancell
Application.DisplayAlerts = False
Activeworkbook.SaveAs . . .
Application.DisplayAlerts = True

--
Regards,
Tom Ogilvy


"pswanie" wrote:

i got a macro to save as a workbook. it needs to overright an excisting
one. how do i get it not to ask/say i am about to overight?
Reply With QuoteReply With Quote