How do I close all open spreadsheets at once?

[cbh]

 

[Ron Coderre]

Try this:

Hold down the SHIFT key...and...
From the Excel Main Menu:
<file><close ALL>

Does that help?
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

 

[Don Guillett]

Here is one I use to save all and close and then close the workbook its in

Sub CLOSE_ALL()
Application.ScreenUpdating = False
Application.DisplayAlerts = False
For Each w In Application.Workbooks
If w.Name <> ThisWorkbook.Name Then
w.Save
w.Close
End If
Next w
ThisWorkbook.Save
Application.Quit
End Sub

 

[cbh]

Ron, I have Office 2007. There is no longer a "File" heading. It has
totally changed and I am totally confused.

 

[Ron de Bruin]

Hold the Shift key and click on the Top right X in 2007

 

[Tyro]

You can go to Microsoft and search for Command Reference 2003, 2007. You'll
get the cross reference for all Office products. You can download the cross
reference and pick an item in the Office 2003 menus, Excel, for example and
the cross reference will show you how to do the same thing in Excel 2007.
Once you get used to the ribbon in Excel 2007, you'll find it much faster
and more intuitive than previous versions of Excel. It just looks more
complex, but is in fact a lot easier. As far as I know, Excel 2007 does not
close all workbooks at the same time by using Shift+Close. It closes one at
a time.

Tyro

For Excel:
http://office.microsoft.com/en-us/excel/HA101491511033.aspx?pid=CH100648241033

 

[Gord Dibben]

See Ron de Bruin's site for graphics of where 2007 commands and menu items are
located.

http://www.rondebruin.nl/0307commands.htm


Gord Dibben MS Excel MVP

 

[Tyro]

That not only closes the workbooks, it closes Excel as well.

Tyro

 

[Ron de Bruin]

you'll find it much faster

Not faster but easier for beginners

 

[Ron de Bruin]

Hi Tyro

If I want to close all workbooks I want to close Excel also.
But maybe the OP want to keep Excel open

Alt F4 is the same as Shift + Click on X

 

[Tyro]

I find it faster. Been working with Excel since Excel 95

Tyro

 

[Tyro]

All the OP said was he/she wants to "close all open workbooks" not close
Excel. Take it from there.

Tyro

 

[Ron de Bruin]

There are not many power users that agree with you Tyro.
For a lot of things you need more clicks.

But there is no way back.

Have a nice weekend

 

[Tyro]

You can do everything with 2007 that you did with prior versions. The menus
just obfuscated things. The ribbon is so much easier. You can still have
your menus, toolbars, functions etc. It's that they just appear in Add-ins.
Everything I've developed over the years is present in Excel 2007. "Power
users"? What do they use?

Tyro