View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
J Wait J Wait is offline
external usenet poster
 
Posts: 6
Default Close workbook without being prompted to save in VBA

I am using the following code to close and save a workbook:

Application.DisplayAlerts = False
ActiveWorkbook.Close SaveChanges:=True

I can't seem to get this to work without prompting me to save, even though I
did application.displayalerts = false and I told it to save in the
active.workbook.close command.