We have a user who would like to close Excel (2003) with the red X but only
close the worksheet he is on, this is how Word works, but Excel closes all
the files. Is there away to change the settins so Excel will only close the
one workbook?

Your user probably has Word set to show each document in the taskbar, but
does not have Excel set that way.

Change the options under Tools->Options->View(?) "show windows in taskbar"


"lroboat" wrote:

> We have a user who would like to close Excel (2003) with the red X but only
> close the worksheet he is on, this is how Word works, but Excel closes all
> the files. Is there away to change the settins so Excel will only close the
> one workbook?

Duke,

Thank you for your answer but both are set to who up as "show each
document", and I tried it on my computer where I know the settings are "show
each document" and it does the same thing.



"Duke Carey" wrote:

> Your user probably has Word set to show each document in the taskbar, but
> does not have Excel set that way.
>
> Change the options under Tools->Options->View(?) "show windows in taskbar"
>
>
> "lroboat" wrote:
>
> > We have a user who would like to close Excel (2003) with the red X but only
> > close the worksheet he is on, this is how Word works, but Excel closes all
> > the files. Is there away to change the settins so Excel will only close the
> > one workbook?

Nope.

Your user will have to train himself not to click on that red x if he wants to
just close a single workbook.

lroboat wrote:
>
> We have a user who would like to close Excel (2003) with the red X but only
> close the worksheet he is on, this is how Word works, but Excel closes all
> the files. Is there away to change the settins so Excel will only close the
> one workbook?

--

Dave Peterson