
Tip #4523 - Double Click to Exit?
Printer Friendly Version | E-Mail This Tip
Double
Click to Exit?
Are you currently
using MS Excel 2007?
Do you sometimes
notice that when you click the red X in the upper right corner of
the title bar, Excel simply closes the workbook, but leaves the program
running?
You've probably
found that you actually have to click the red X again to get out of
Excel, right?
Well, I don't
know about you, but that drives me crazy! I liked the quick escape
hatch better. You know, you click the red X and Excel closes everything,
asking you what to save along the way. So, what was the problem?
Well, after quite
a bit of experimenting, I finally stumbled upon the reason for this
weird behavior.
It seems I only
experience this problem when I have a hidden workbook. When I use
the red X while a workbook is hidden, the program doesn't close with
just one click. But, if all the workbooks are unhidden, it functions
just as it always did.
So, it seems your
only recourse is to never keep a workbook hidden. Or, is it?
I found that,
once again, the Quick Access Toolbar saves the day!
If you use hidden
workbooks and still want a swift exit, give this a try.
First, click
the down arrow to the right of the Quick Access Toolbar and
choose More Commands at the bottom. You'll then be
taken here:

Choose All
Commands in the Choose commands from field.
Scroll down and
find the Exit command.
Use the Add
button in the middle to move it to the command list for the
Quick Access Toolbar on the right.
You can then use
the up and down buttons on the far right to place
the command in the location you desire.
When everything
looks good to you, simply click OK.
Voila!
So, the next time
you have hidden workbooks and try to exit Excel, just click the Exit
button on the Quick Access Toolbar instead of the red X and you'll
be out of there with just one click!
~ April
Want To Comment On This Tip? Click Here! We'd love to hear from you :-)
Like These Tips? Get 'Em Free In Your E-mail