How do I close all open spreadsheets at once?

R

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)
 
D

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
 
C

cbh

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

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
 
R

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
 
T

Tyro

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

Tyro
 
R

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
 
T

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
 
Top