CODEWITHSUNDEEP
excelvba
James
James

Reputation: 2474

Two methods of suppressing the save changes dialog in Excel are not working

Before setting Application.DisplayAlerts = False It gets set to false Yet it still gives me the save as!

For those who don't like images:

  Close logFile
  Application.DisplayAlerts = False 
  If WasOpened2 Then Workbooks(FilenameNoPath(FoundFiles(i))).Close False 
  Application.DisplayAlerts = True

Application.DisplayAlerts = False should suppress any and all alerts from excel. Furthermore, I'm led to believe that passing False to .Close should automatically not save changes on the workbook. Yet I still get a prompt. Any ideas?

Upvotes: 2

Views: 6026

Answers (1)

James
James

Reputation: 2474

I had the inkling that another Excel add-in that was running alongside could be causing the issue. Coworker suggested to wrap with code to suppress events. This worked:

  Application.EnableEvents = False
  Application.DisplayAlerts = False
  If WasOpened2 Then Workbooks(FilenameNoPath(FoundFiles(i))).Close False 
  Application.DisplayAlerts = True
  Application.EnableEvents = True

Upvotes: 3

Related Questions