Disable Close all Windows

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I often have many Excel workbooks open and when I'm working quickly, I
usually hit the red X when I just want to close one (out of habit). This
closes all the workbooks, and while I am fortunately reminded when the save
prompt comes up, it is still very annoying. Is there any way to disable this
feature so that it only closes the active workbook?
 
You could simply click the "X" *UNDER* the red X to close the active WB.

However, what I have done for myself, is place the "close" icon on the left
side of my toolbar.
It becomes second nature after a while, to go LEFT to "close" and go RIGHT
to "exit" XL.

--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

I often have many Excel workbooks open and when I'm working quickly, I
usually hit the red X when I just want to close one (out of habit). This
closes all the workbooks, and while I am fortunately reminded when the save
prompt comes up, it is still very annoying. Is there any way to disable
this
feature so that it only closes the active workbook?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Providing user message when RED X clicked & properly closing application. 2
Disable Macro Alert 2
close workbook without saving or promt to save 3
exiting excel ONLY the workbook will close 12
Close Workbook in Excel 3
Close vs. Exit in 2007 1
Macro to close Excel 2007 2
Closing Workbook with "X" closes all workbooks... 2

Back
Top