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

Tyro


"Ron de Bruin" wrote in message
...
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


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Tyro" wrote in message
. net...
That not only closes the workbooks, it closes Excel as well.

Tyro

"Ron de Bruin" wrote in message
...
Hold the Shift key and click on the Top right X in 2007

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


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

"Ron Coderre" wrote:

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)

"cbh" wrote in message
...