Results 1 to 13 of 13

Thread: Blank Screen

  1. #1
    Bronze Lounger
    Join Date
    Jan 2001
    Posts
    1,418
    Thanks
    1
    Thanked 0 Times in 0 Posts
    Problem: Every time I close an Excel worksheet/file, I get a blank, greyed-out Excel screen. I am then forced to close that as well in order to get completely out of Excel. Any way I can eliminate this last step-it is very annoying!
    Thanks in advance.

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    Instead of closing the file, quit excel, either from the File - Exit or the "X" at the upper right.

    Steve

  3. #3
    Bronze Lounger
    Join Date
    Jan 2001
    Posts
    1,418
    Thanks
    1
    Thanked 0 Times in 0 Posts
    [quote name='sdckapr' post='778967' date='09-Jun-2009 09:20']Instead of closing the file, quit excel, either from the File - Exit or the "X" at the upper right.

    Steve[/quote]

    Thanks Steve, it works for the File Exit option, but not from the "X" option.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    There should be two close buttons.
    [attachment=84195:x.png]
    Attached Images Attached Images
    • File Type: png x.png (93.7 KB, 3 views)

  5. #5
    Bronze Lounger
    Join Date
    Jan 2001
    Posts
    1,418
    Thanks
    1
    Thanked 0 Times in 0 Posts
    [quote name='HansV' post='778990' date='09-Jun-2009 11:26']There should be two close buttons.
    [attachment=84195:x.png][/quote]

    Hans,
    Thanks. Yes, either one of the "X"s results in a blank screen-I tried them both!

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    Does the setting for "Show windows in taskbar" in the View tab of Tools | Options make a difference (it shouldn't but you never know...)

  7. #7
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    Are you using Excel 2007? If so, hold Shift and click the topmost X to close all. (this should only be necessary if you have files in your XLSTART directory)
    Regards,
    Rory

    Microsoft MVP - Excel

  8. #8
    Bronze Lounger
    Join Date
    Jan 2001
    Posts
    1,418
    Thanks
    1
    Thanked 0 Times in 0 Posts
    [quote name='rory' post='779063' date='10-Jun-2009 03:00']Are you using Excel 2007? If so, hold Shift and click the topmost X to close all. (this should only be necessary if you have files in your XLSTART directory)[/quote]

    Rory,
    That did the trick. Where would I see these files in my XLSTART directory?
    Thanks.

  9. #9
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    [quote name='jlkirk' post='779078' date='10-Jun-2009 12:36']Where would I see these files in my XLSTART directory?[/quote]

    Um, yes. (use Windows Explorer)
    If you have a personal macro workbook, then you have a file in one of your XLSTART directories.
    Regards,
    Rory

    Microsoft MVP - Excel

  10. #10
    Bronze Lounger
    Join Date
    Jan 2001
    Posts
    1,418
    Thanks
    1
    Thanked 0 Times in 0 Posts
    [quote name='rory' post='779079' date='10-Jun-2009 06:38']Um, yes. (use Windows Explorer)
    If you have a personal macro workbook, then you have a file in one of your XLSTART directories.[/quote]

    OK, this didn't used to happen in 03 when I had macros in my workbooks. What has changed, and how do I get it back to how it was in 03 without deleting the macros?
    Thanks.

  11. #11
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    [quote name='jlkirk' post='779083' date='10-Jun-2009 13:26']OK, this didn't used to happen in 03 when I had macros in my workbooks. What has changed, and how do I get it back to how it was in 03 without deleting the macros?[/quote]

    It has nothing to do with having macros in workbooks, it is to do with files in XLSTART. (it's just that if you have a personal macro workbook, it needs to be in your XLSTART directory). It's just an issue with 2007. You can either use the Shift+Click or you can use the Exit Excel menu item.
    Regards,
    Rory

    Microsoft MVP - Excel

  12. #12
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    See A working solution for a workaround.

    (If you read the other posts in that topic you'll see that this intentional change has made a lot of Excel users VERY unhappy!)

  13. #13
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    [quote name='HansV' post='779085' date='10-Jun-2009 13:35'](If you read the other posts in that topic you'll see that this intentional change has made a lot of Excel users VERY unhappy!)[/quote]

    Like so many things in 2007...
    Regards,
    Rory

    Microsoft MVP - Excel

Posting Permissions

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