Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old September 21st 15, 12:34 AM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Dec 2012
Posts: 5
Default 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
should.

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?

Thank you.

  #2   Report Post  
Old September 21st 15, 07:36 AM
Junior Member
 
First recorded activity by ExcelBanter: Jun 2015
Posts: 10
Default

http://eco-site.org/


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
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


All times are GMT +1. The time now is 06:52 AM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017