If you type:-

close all workbooks

- into the F 1 Help Facility you will see all of the options that are
available.

Please hit Yes if my comments have helped.

"Alojz" wrote:

Hi, in Excel 2003 I am able to close all open workbooks at once. Click on x
button on one of workbooks while holding shift key does it. I remember
somebody posted how to do the same in Excel 2007, but forgot the trick. It
has something to do with general setup of Excel. Any idea? Thanks in advance.
Alojz