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?

I'm using 2007 and I sure see it. Of course, that only pops up when closing
Excel, not when closing ONLY the active sheet.

In earlier versions you could hold down the shift key and click on the File
menu to get the option to Close All - is that what you are thinking of?

"dustyr" wrote:

To Duke Carey:
To answer your question: Yes, "Yes to all" is the feature I'm looking for,
however, the 2007 version of Exel does not show it and I don't know where to
look.


"Duke Carey" wrote:

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?

Close All is listed under "Commands not in Ribbon", so I'm guessing
there is no other way.


On Aug 16, 8:49 pm, Duke Carey
wrote:
You can modify the Quick Access Toolbar (QAT) and add the Close All command.
No idea how you can access it otherwise.



"dustyr" wrote:
To Duke Carey:
To answer your question: Yes, "Yes to all" is the feature I'm looking for,
however, the 2007 version of Exel does not show it and I don't know where to
look.

"Duke Carey" wrote:

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? - Hide quoted text -

- Show quoted text -