Thread: Disable Alert
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
[email protected] YoureNotAtHomeNow@googlemail.com is offline
external usenet poster
 
Posts: 17
Default Disable Alert

On May 6, 8:37*pm, Per Jessen wrote:
Hi

Excel will always prompt the user to save an unsaved file before
closing it.

Another solution to close without saving:

ThisWorkbook.Close SaveChanges:=False

Regards,
Per





Thanks. *It worked. *Any ideas why my first try didn't work?-- Hide quoted text -


- Show quoted text -


Thanks, All.