Closing multiple Excel workbooks

[zsjoy]

I need to have several workbooks open at once, making changes to each separately, flipping back & forth, etc. Now that I have MS Office 2007, I can not find a way to close all the workbooks at once, saving changes to all - "yes to all" button is not there when I close. Can you help me find a way to do this? It is very frustrating to answer "yes" to each of the 30-some-odd workbooks I have open.

 

[nbrcrunch]

I was just reading an article about this yesterday. Go into the QAT (Quick Access Toolbar) setting, look for All Commands. Then find the icon to close all books. Add that to the QAT and you're set to go.

 

[zsjoy]

Thank You!!! I really do appreciate your help. This is huge for me.

Now if somebody could remedy the color resolution of the pale blue/silver/black issue...

Thanks again.