If I have unsaved changes in more than one file I am asked

"Do you want to save changes to " & [active workbook's name]

The buttons are Yes, Yes to All, No, and Cancel

Isn't *Yes to All* the feature you seek?

"dustyr" wrote:

Upon creating or making changes to multiple Excel Work Sheets in 2007, and
then clicking "close", a pop up question appears asking if you want to "save"
the Work Sheet. In Excel 2003, the pop up question asks if you want to
"save" the displayed Work Sheet, or "Save All". Is there a way of "Saving
All" in Excel 2007?