Excel 2007 - Closing One Sheet at a Time?
 

I have Excel 2007 and tend to open multiple sheets at a time. In
Excel 2003, when you elect to close the program, it would close all
opened sheet, except those with changes (it asks if you want to save).
In Excel 2007, it requires you to close each opened sheet manually. Is
there a way to get Excel 2007 to close all sheets when one elects to
close the program - I hate these extra steps!

I looked thru the Options, but did not see a entry for what I want.
Does anyone have any advice/suggestions?

Thanks
Charliec
************************************************** ****
Charliec

Excel 2007 - Closing One Sheet at a Time?
 

Hi, Are you talking about sheets or workbooks??

Excel 2007 - Closing One Sheet at a Time?
 

Hi Charliec

In Excel 2007 you can double click on the Office Buttton (round button next to the Home tab)

--

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


"Charliec" wrote in message ...
I have Excel 2007 and tend to open multiple sheets at a time. In
Excel 2003, when you elect to close the program, it would close all
opened sheet, except those with changes (it asks if you want to save).
In Excel 2007, it requires you to close each opened sheet manually. Is
there a way to get Excel 2007 to close all sheets when one elects to
close the program - I hate these extra steps!

I looked thru the Options, but did not see a entry for what I want.
Does anyone have any advice/suggestions?

Thanks
Charliec
************************************************** ****
Charliec

Excel 2007 - Closing One Sheet at a Time?
 

On Sat, 20 Oct 2007 02:12:02 -0000, "D." wrote:

Hi, Are you talking about sheets or workbooks??

I guess that would be workbooks.
************************************************** ****
Charliec

Excel 2007 - Closing One Sheet at a Time?
 

You can set your view settings so that all Excel windows are not shown in
the taskbar. I don't know exactly where this is, click on the round Office
button, click Excel Options, and check out the various view options.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______



"Charliec" wrote in message
...
I have Excel 2007 and tend to open multiple sheets at a time. In
Excel 2003, when you elect to close the program, it would close all
opened sheet, except those with changes (it asks if you want to save).
In Excel 2007, it requires you to close each opened sheet manually. Is
there a way to get Excel 2007 to close all sheets when one elects to
close the program - I hate these extra steps!

I looked thru the Options, but did not see a entry for what I want.
Does anyone have any advice/suggestions?

Thanks
Charliec
************************************************** ****
Charliec