Thread: How do I bypass the message to save when closing a file by macro?
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
  
Posts: 6,953
Default How do I bypass the message to save when closing a file by macro?
activeworkbook.Close SaveChanges:=False

--
Regards,
Tom Ogilvy


" wrote:

When closing a file via macro, I continue to get the message do I want to
save this file. Can someone help me bypass that message.
Reply With QuoteReply With Quote