Excel - "Yes to All" when saving changes upon close

[nittanylions]

Hi all,

I'm having issues when closing multiple files. I click the red X in the upper right hand corner, and choose "Yes to All" when the dialog box asks me if I want to save any changes. The problem I have is that when I choose "Yes to All", it seems to close an add-in that I use before saving and therefore all the files are saved with #VALUE references everywhere there are cells that rely on the add-in (which is most of the cells in every file). I never had this issue before and I'm not sure why it started now.

Any suggestions on how to get around this?

Also, this doesn't happen when closing an individual file. Only happens when using "Yes to All" save option.

[dumples]

Add a routine to your add-in workbook to save all open workbooks and then close itself.

something short will probably do

 
Sub closeAllOpenBooks()
dim wb as workbook
for each wb in application.workbooks
 if wb.name<> thisworkbook.name then wb.close(true)
next wb
thisworkbook.close(true)
end sub

Note, I don't generally use add-ins, so I am not 100% that the thisworkbook.close line will work or is necessary.