Results 1 to 5 of 5
  1. #1
    2 Star Lounger bmeacham's Avatar
    Join Date
    Jan 2001
    Location
    Austin, Texas, USA
    Posts
    191
    Thanks
    4
    Thanked 4 Times in 4 Posts

    Close only one spreadsheet of many open (2002 SP-2)

    When I have more than one spreadsheet open and I click the large Close button (not the small one that pertains only to the spreadsheet that I am looking at), Excel closes all the spreadsheets. This differs from how Word does it. When I have more than one Word document open and I click the large Close button (not the small one that pertains only to the document that I am looking at), Word closes only the one document and leaves the others open. How can I get Excel to act as Word does when I click the large Close button?
    Bill Meacham
    bmeacham98 AT yahoo.com

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Close only one spreadsheet of many open (2002 SP-2)

    Excel doesn't go as far as Word in faking a single-document interface. I don't think it 'll be easy to make Excel behave like Word, there is no Before Quit event or something like that (but I'll gladly be proved wrong by the experts!)

    Personally, I find Word's behavior very annoying, I prefer that of Excel - it makes sense to click the close button of a workbook to close that workbook, and to click the close button of Excel to quit Excel. Why have two buttons with the same function, as in Word?

  3. #3
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Close only one spreadsheet of many open (2002 SP-2)

    Word 2002 can be changed, see:

    http://www.mvps.org/word/FAQs/Customization/SDIMDI.htm

    I don't know if Romke Soldaat's code to change Word 2000 is still available, it doesn't show on his own website.

    I also thought I had read that registry hacks were available to change between MDI & SDI, but I can't find anything.
    -John ... I float in liquid gardens
    UTC -7ąDS

  4. #4
    3 Star Lounger
    Join Date
    Jul 2001
    Location
    San Jose, California, USA
    Posts
    290
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Close only one spreadsheet of many open (2002 SP-2)

    I don't know which version Word you are using but I have 2002 SP-2 and if I click the large close button Word closes, no matter how many documents I have open. To disable the annoying MDI, and remove those multiple icons from the task bar, uncheck the 'Windows in Taskbar' option in the 'View' tab of the options menu.

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Close only one spreadsheet of many open (2002 SP-2)

    Hmm, very strange. I had unchecked "Windows in Taskbar" for this very reason, and recently noticed that clicking the upper Close button didn't quit Word. Guess what? "Windows in Taskbar" was checked again! I'm sure I didn't do that myself, because I don't like the "new" behavior. Oh, well. Thanks for reminding me to look at this option again. I unchecked it immediately, of course. Let's see how long it stays that way...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •