Closing only the current workbook instead of all workbooks 
Author Message
 Closing only the current workbook instead of all workbooks

In previous versions of Excel, if you clicked the Close X
at the top right corner of the screen, only the current
workbook would close.  In Excel 2002, all workbooks close
when the X is clicked.  Is there a way to change this
setting back to the way it was in previous versions?  I
have noticed that this only changed in Excel 2002.  The
Close X still works as it did in previous version for all
of the other Office 2002 applications.


Tue, 18 Oct 2005 19:41:55 GMT  
 Closing only the current workbook instead of all workbooks
You must be hitting the Excel Application X as opposed to the Workbook Window X.  Is the Worksheet and workbook
protected, including protecting structure and windows?  If so then you will not see a X for the workbook, and therefore
the only X you could click on would be the Application X.

--
Regards
           Ken.......................    Microsoft MVP - Excel
                   Sys Spec - Win XP Pro /  XL2K & XLXP

----------------------------------------------------------------------------
Polite Request - It is very very much appreciated in
text-only groups if you do not attach files - Thanks
----------------------------------------------------------------------------

Quote:

> In previous versions of Excel, if you clicked the Close X
> at the top right corner of the screen, only the current
> workbook would close.  In Excel 2002, all workbooks close
> when the X is clicked.  Is there a way to change this
> setting back to the way it was in previous versions?  I
> have noticed that this only changed in Excel 2002.  The
> Close X still works as it did in previous version for all
> of the other Office 2002 applications.



Tue, 18 Oct 2005 19:48:18 GMT  
 Closing only the current workbook instead of all workbooks
It is the Excel Application X that I am referring to.  If
I use the Workbook Window X, it will only close that
workbook like it should.  Its just that the Excel
Application X used to only close the current workbook.  
If you try the same thing with mulitple documents in
Word, the Word Application X only closes the current
document.  Previous versions of Excel worked the same way.

The problem that I am experiencing with this is that I am
currently getting ready to roll Office 2002 out to 5000+
users who will notice this difference.  So far in a
minimal pilot user group, every user has expressed
concern over this change.  I would like to avoid having
to re-train users or burden them with documentation (that
I know they will not read) warning them of this change.

Any ideas?  I've looked throughout the build kits and I
cannot find any differences related to this in any of the
Office Applications.

Quote:
>-----Original Message-----
>You must be hitting the Excel Application X as opposed

to the Workbook Window X.  Is the Worksheet and workbook
Quote:
>protected, including protecting structure and windows?  

If so then you will not see a X for the workbook, and
therefore
Quote:
>the only X you could click on would be the Application X.

>--
>Regards
>           Ken.......................    Microsoft MVP -
Excel
>                   Sys Spec - Win XP Pro /  XL2K & XLXP

>---------------------------------------------------------
-------------------
>Polite Request - It is very very much appreciated in
>text-only groups if you do not attach files - Thanks
>---------------------------------------------------------
-------------------




- Show quoted text -

Quote:
>> In previous versions of Excel, if you clicked the
Close X
>> at the top right corner of the screen, only the current
>> workbook would close.  In Excel 2002, all workbooks
close
>> when the X is clicked.  Is there a way to change this
>> setting back to the way it was in previous versions?  I
>> have noticed that this only changed in Excel 2002.  The
>> Close X still works as it did in previous version for
all
>> of the other Office 2002 applications.

>.



Tue, 18 Oct 2005 20:01:07 GMT  
 Closing only the current workbook instead of all workbooks
For me - In both XL2000, XL2002 (And 97 as far as I remember)

Open Excel, hit New Workbook Icon 10 times, hit Application X and all files close - Bye Bye Excel in each case - Have
never known it be any different.  Take your point though re Word, so I know what you are referring to.

--
Regards
           Ken.......................    Microsoft MVP - Excel
                   Sys Spec - Win XP Pro /  XL2K & XLXP

----------------------------------------------------------------------------
Polite Request - It is very very much appreciated in
text-only groups if you do not attach files - Thanks
----------------------------------------------------------------------------

Quote:

> It is the Excel Application X that I am referring to.  If
> I use the Workbook Window X, it will only close that
> workbook like it should.  Its just that the Excel
> Application X used to only close the current workbook.
> If you try the same thing with mulitple documents in
> Word, the Word Application X only closes the current
> document.  Previous versions of Excel worked the same way.

> The problem that I am experiencing with this is that I am
> currently getting ready to roll Office 2002 out to 5000+
> users who will notice this difference.  So far in a
> minimal pilot user group, every user has expressed
> concern over this change.  I would like to avoid having
> to re-train users or burden them with documentation (that
> I know they will not read) warning them of this change.

> Any ideas?  I've looked throughout the build kits and I
> cannot find any differences related to this in any of the
> Office Applications.

> >-----Original Message-----
> >You must be hitting the Excel Application X as opposed
> to the Workbook Window X.  Is the Worksheet and workbook
> >protected, including protecting structure and windows?
> If so then you will not see a X for the workbook, and
> therefore
> >the only X you could click on would be the Application X.

> >--
> >Regards
> >           Ken.......................    Microsoft MVP -
> Excel
> >                   Sys Spec - Win XP Pro /  XL2K & XLXP

> >---------------------------------------------------------
> -------------------
> >Polite Request - It is very very much appreciated in
> >text-only groups if you do not attach files - Thanks
> >---------------------------------------------------------
> -------------------



> >> In previous versions of Excel, if you clicked the
> Close X
> >> at the top right corner of the screen, only the current
> >> workbook would close.  In Excel 2002, all workbooks
> close
> >> when the X is clicked.  Is there a way to change this
> >> setting back to the way it was in previous versions?  I
> >> have noticed that this only changed in Excel 2002.  The
> >> Close X still works as it did in previous version for
> all
> >> of the other Office 2002 applications.

> >.



Tue, 18 Oct 2005 20:44:25 GMT  
 Closing only the current workbook instead of all workbooks
Your right as far as XL2000 and XL2002, but not in 97.  I
guess therein lies my problem; almost all of my users are
still using 97.  Any idea as to why it was changed in
XL2000 and on but not in the other Office Apps?  I would
think a change like that should be consistent throughout
the Office Suite.  Anyway, I guess everyone will learn
the difference eventually.

Thanks!

Quote:
>-----Original Message-----
>For me - In both XL2000, XL2002 (And 97 as far as I
remember)

>Open Excel, hit New Workbook Icon 10 times, hit

Application X and all files close - Bye Bye Excel in each
case - Have
Quote:
>never known it be any different.  Take your point though

re Word, so I know what you are referring to.
Quote:

>--
>Regards
>           Ken.......................    Microsoft MVP -
Excel
>                   Sys Spec - Win XP Pro /  XL2K & XLXP

>---------------------------------------------------------
-------------------
>Polite Request - It is very very much appreciated in
>text-only groups if you do not attach files - Thanks
>---------------------------------------------------------
-------------------




- Show quoted text -

Quote:
>> It is the Excel Application X that I am referring to.  
If
>> I use the Workbook Window X, it will only close that
>> workbook like it should.  Its just that the Excel
>> Application X used to only close the current workbook.
>> If you try the same thing with mulitple documents in
>> Word, the Word Application X only closes the current
>> document.  Previous versions of Excel worked the same
way.

>> The problem that I am experiencing with this is that I
am
>> currently getting ready to roll Office 2002 out to
5000+
>> users who will notice this difference.  So far in a
>> minimal pilot user group, every user has expressed
>> concern over this change.  I would like to avoid having
>> to re-train users or burden them with documentation
(that
>> I know they will not read) warning them of this change.

>> Any ideas?  I've looked throughout the build kits and I
>> cannot find any differences related to this in any of
the
>> Office Applications.

>> >-----Original Message-----
>> >You must be hitting the Excel Application X as opposed
>> to the Workbook Window X.  Is the Worksheet and
workbook
>> >protected, including protecting structure and windows?
>> If so then you will not see a X for the workbook, and
>> therefore
>> >the only X you could click on would be the
Application X.

>> >--
>> >Regards
>> >           Ken.......................    Microsoft
MVP -
>> Excel
>> >                   Sys Spec - Win XP Pro /  XL2K &
XLXP

>> >------------------------------------------------------
---
>> -------------------
>> >Polite Request - It is very very much appreciated in
>> >text-only groups if you do not attach files - Thanks
>> >------------------------------------------------------
---
>> -------------------



>> >> In previous versions of Excel, if you clicked the
>> Close X
>> >> at the top right corner of the screen, only the
current
>> >> workbook would close.  In Excel 2002, all workbooks
>> close
>> >> when the X is clicked.  Is there a way to change
this
>> >> setting back to the way it was in previous
versions?  I
>> >> have noticed that this only changed in Excel 2002.  
The
>> >> Close X still works as it did in previous version
for
>> all
>> >> of the other Office 2002 applications.

>> >.

>.



Tue, 18 Oct 2005 21:05:44 GMT  
 
 [ 5 post ] 

 Relevant Pages 

1. Macro to open a workbook, work in that workbook, than close the workbook (saved)

2. Closing 1 workbook closes all workbooks

3. Copy Macro from current workbook to a new workbook

4. Copy worksheet from another workbook to current workbook

5. Workbook wont save if 4 or more sheets in current workbook

6. All Excel closes instead of the workbook

7. Attaching custom toolbar to workbook - Toolbar must not show when workbook closes

8. Copy data from a closes workbook to another workbook

9. Disabling a closed workbook from an open workbook

10. Copying Sheets from a closed workbook into an open workbook


 
Powered by phpBB® Forum Software © phpBB Group