Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Close Workbook in Excel

User has Excel 2003 SP3. She likely previously had either 2000 or 2002.

If she has several workbooks open and/or minimized, then clicks the
uppermost right X on the active workbook, it closes Excel and all the other
workbooks, not just the active workbook. She is adament that Excel did not
used to work like this, that the uppermost X would close only the active
workbook. Can anyone confirm this change in behavior and/or let us know if
there is a way to change the behavior to close only the active workbook and
not the program? Thanks in advance.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,316
Default Close Workbook in Excel

On your users PC, open Excel and do the following:

1. Click TOOLS on the menu
2. Select OPTIONS from the drop-down menu
3. If necessary, click the VIEW tab of the dialog box
4. Click the WINDOWS IN TASKBAR check box.

Now each time a file is opened it opens in a separate session.

Hope this helps...
--
Kevin Backmann


"Brenda from Michigan" wrote:

User has Excel 2003 SP3. She likely previously had either 2000 or 2002.

If she has several workbooks open and/or minimized, then clicks the
uppermost right X on the active workbook, it closes Excel and all the other
workbooks, not just the active workbook. She is adament that Excel did not
used to work like this, that the uppermost X would close only the active
workbook. Can anyone confirm this change in behavior and/or let us know if
there is a way to change the behavior to close only the active workbook and
not the program? Thanks in advance.

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 449
Default Close Workbook in Excel

Your friend is wrong. The uppermost X has always closed Excel. Think of it
as an application surrounding the open Excel files inside of it.

The way is to upgrade to Excel 2007, which doesn't mind which X you click,
it refuses to close.

HTH. Best wishes Harald

"Brenda from Michigan" <Brenda from
wrote in message ...
User has Excel 2003 SP3. She likely previously had either 2000 or 2002.

If she has several workbooks open and/or minimized, then clicks the
uppermost right X on the active workbook, it closes Excel and all the
other
workbooks, not just the active workbook. She is adament that Excel did
not
used to work like this, that the uppermost X would close only the active
workbook. Can anyone confirm this change in behavior and/or let us know
if
there is a way to change the behavior to close only the active workbook
and
not the program? Thanks in advance.


  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5,934
Default Close Workbook in Excel

To add to Harald posting...

IF the worksheets are NOT set to maximize, then each worksheet is in its own
"smaller" window (technical term is it is a Child Form for Excel's MDI Form)
and each worksheet has it own X to close itself. But if the worksheets are
set to maximize, then they fill the client area Excel provides for them and
the X your friend is looking at is Excel's X, not the worksheet's. You can
still close each worksheet separately with this setting, but the X is
smaller and located at the right side of the Menu Bar.

--
Rick (MVP - Excel)


"Harald Staff" wrote in message
...
Your friend is wrong. The uppermost X has always closed Excel. Think of it
as an application surrounding the open Excel files inside of it.

The way is to upgrade to Excel 2007, which doesn't mind which X you click,
it refuses to close.

HTH. Best wishes Harald

"Brenda from Michigan" <Brenda from
wrote in message
...
User has Excel 2003 SP3. She likely previously had either 2000 or 2002.

If she has several workbooks open and/or minimized, then clicks the
uppermost right X on the active workbook, it closes Excel and all the
other
workbooks, not just the active workbook. She is adament that Excel did
not
used to work like this, that the uppermost X would close only the active
workbook. Can anyone confirm this change in behavior and/or let us know
if
there is a way to change the behavior to close only the active workbook
and
not the program? Thanks in advance.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
exiting excel ONLY the workbook will close Brandon Excel Discussion (Misc queries) 12 May 27th 10 09:59 PM
close workbook without closing excel and stop recursive function chris Excel Discussion (Misc queries) 3 July 10th 06 08:23 PM
Option in Excel to save a close a workbook inactive for 5 minutes Patricia Peterson Excel Discussion (Misc queries) 4 January 5th 06 05:00 PM
Excel shoud not close all active books when clicking close button technomike Excel Discussion (Misc queries) 0 June 10th 05 05:35 PM
excel - Windows close button (x) should only close active workboo. CoffeeAdict Setting up and Configuration of Excel 3 February 8th 05 04:30 AM


All times are GMT +1. The time now is 10:00 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"