|If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.|
||Thread Tools||Display Modes|
Extra window that must be closed
I am using Microsoft Office 2010 in Windows 7.
Preciously when I would launch Excel 2010 it would start with a new,
blank file named "Book1" and that file would be in the number 1 window
of Excel. If I wanted to open an existing file I would do so and
existing file would then become the number 1 window of Excel. If I
then clicked on the "Close" button (not the "Close Window" button) at
the upper right hand corner of the window Excel would close as it
Recently I created a Book.xltx and Sheet.xltx templates to have my
preferences included in all new Excel files. Those are both now stored
in the C:\Users\Gordon\AppData\Roaming\Microsoft\Excel\XL START
directory. As I had wanted, all new files and sheets have the
preferences I saved in those files.
There is one unwanted side affect the new templates has created.
When I launch Excel 2010 it starts with a new, blank file named
"Book1" and that file is in the number 1 window of Excel. That part is
no different than before. However, if I then open an existing file
then that existing file becomes the number 2 window of Excel. Now
there are two active Excel windows. If I click on the "Close" button
(not the "Close Window" button) at the upper right hand corner of the
window, Excel will now close only the active window -- I have to click
on the "Close" button again to close the window that contains "Book1."
Is there a way to have an existing file, when opened, become the
number 1 window as it used to?
|Thread||Thread Starter||Forum||Replies||Last Post|
|Excel crashes when VBA window is closed||[email protected]||Excel Programming||2||June 27th 07 11:02 AM|
|Differente .xls files generated when VBE window closed vs open||Mark||Excel Programming||3||June 26th 07 02:15 PM|
|how to get alert message when window is closed in excel for blank||Anitha||Excel Discussion (Misc queries)||0||November 30th 06 07:08 AM|
|Excel window closed but process still running||Jessica[_5_]||Excel Programming||2||June 23rd 06 02:44 AM|
|Macro that waits, then resumes after window is closed||[email protected]||Excel Programming||3||January 16th 05 04:32 PM|