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

    Home » Forums » AskWoody support » Productivity software by function » MS Excel and spreadsheet help » Close only one spreadsheet of many open (2002 SP-2)

    Author
    Topic
    bmeacham
    AskWoody Plus
    November 17, 2003 at 4:40 pm #396655

    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?

    Reply | Quote
    Viewing 1 reply thread
    Author
    Replies
    • WSHansV
      AskWoody Lounger
      November 17, 2003 at 4:51 pm #744932

      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?

      Reply | Quote
      • WSJohnBF
        AskWoody Lounger
        November 17, 2003 at 6:23 pm #744953

        Word 2002 can be changed, see:

        http://www.mvps.org/word/FAQs/Customization/SDIMDI.htm%5B/url%5D

        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.

        Reply | Quote
      • WSJohnBF
        AskWoody Lounger
        November 17, 2003 at 6:23 pm #744954

        Word 2002 can be changed, see:

        http://www.mvps.org/word/FAQs/Customization/SDIMDI.htm%5B/url%5D

        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.

        Reply | Quote
      • WSasimpkins
        AskWoody Lounger
        November 17, 2003 at 6:47 pm #744963

        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.

        Reply | Quote
        • WSHansV
          AskWoody Lounger
          November 17, 2003 at 7:36 pm #744987

          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…

          Reply | Quote
        • WSHansV
          AskWoody Lounger
          November 17, 2003 at 7:36 pm #744988

          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…

          Reply | Quote
      • WSasimpkins
        AskWoody Lounger
        November 17, 2003 at 6:47 pm #744964

        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.

        Reply | Quote
    • WSHansV
      AskWoody Lounger
      November 17, 2003 at 4:51 pm #744933

      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?

      Reply | Quote
    Viewing 1 reply thread
    Reply To: Close only one spreadsheet of many open (2002 SP-2)

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information:




DON'T MISS OUT!
Subscribe to the Free Newsletter
We promise not to spam you. Unsubscribe at any time.
Invalid email address

View the Forum

  • Recent Replies
  • My Replies
  • My Active Topics
  • New Posts in the Last day
  • Private Messages
  • Knowledge Base
  • How to use the Forums
  • All Forums

    • Recent Topics

    My Profile

    May 2025
    S M T W T F S
     123
    45678910
    11121314151617
    18192021222324
    25262728293031

    Remembering Woody

     

    Want to Advertise in the free newsletter? How about a gift subscription in honor of a birthday? Send an email to sb@askwoody.com to ask how.

    Mastodon profile for DefConPatch
    Mastodon profile for AskWoody

     

    Home • About • FAQ • Posts & Privacy • Forums • My Account
    Register • Free Newsletter • Plus Membership • Gift Certificates • MS-DEFCON Alerts

    Copyright ©2004-2025 by AskWoody Tech LLC. All Rights Reserved.