Stop Excel from closing ALL windows when clicking the X

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

Guest

I'm using Office 2k. When I open multiple Excel files it opens them in completely different instances of Excel. However when I click the top X it closes all of them. I know there's a way to make it NOT close them all but close just the one I'm working on but I can't remember where that is

Can someoen refrehs my memory

THanks.
 
When I open multiple Excel files it opens them in completely different
instances of Excel.

Actually it may be just one instance of Excel but look like multiple
instances if you have "windows in taskbar" selected under Tools, Options,
View.

This will be more obvious if you do not maximize your spreadsheet windows.
 
Mr B.

Is it sure that there are more instances of Excel ?
Or are you thinking so because Excel shows more than one (minimized) window
on the taskbar.
It that is the case, you can stop it by unchecking "Windows in taskbar" via
Tools / Options / View tab and uncheck.

--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *

Mr B said:
I'm using Office 2k. When I open multiple Excel files it opens them in
Click to expand...
completely different instances of Excel. However when I click the top X it
closes all of them. I know there's a way to make it NOT close them all but
close just the one I'm working on but I can't remember where that is.
 
Click the X for the window not the application. (interior X)


: I'm using Office 2k. When I open multiple Excel files it opens them in
completely different instances of Excel. However when I click the top X it
closes all of them. I know there's a way to make it NOT close them all but
close just the one I'm working on but I can't remember where that is.
:
: Can someoen refrehs my memory.
:
: THanks.
 
I don't think so Mr B.
Closing the application also means closing its windows.

If you want to change that you will have to make sure that clicking the X
you mean, doesn't mean "closing" the application.

I think you could do so by writing a before-close macro which actually
closes the windows and than brakes off the closing of the application, but
I'm not sure of it.
Certainly someone else will shed light on that.

--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *

Mr B said:
Well I like having them shown separately in the Task Bar, I just don't
Click to expand...
want them all to close at the same time when I click the Upper X because
it's just natural for me to click that X instead of the one just for the
windows I'm working on...
 
It is not like Word, and clicking the X you are will close ALL windows. Either
click the window X or live with it I'm afraid.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------



Mr B said:
Well I like having them shown separately in the Task Bar, I just don't want
Click to expand...
them all to close at the same time when I click the Upper X because it's just
natural for me to click that X instead of the one just for the windows I'm
working on...
 
Back
Top