[Cleffer]

Excel Office 2003 SP2, v.11.8105

I got a complaint about a user having multiple spreadsheets open and then clicking on the program X to close the one sheet and it closes Excel and *all* the spreadsheets. Of course, there's a small black X to close the sheet just under the program X, but apparently, that's too hard.

Anyone know of a setting anywhere or of a UI tweak that changes this so the red program x just closes the one spreadsheet?

 

[Cleffer]

Hi

There is an easy way that involves VBA code, but my question would then be - "How should the workbook be closed?" Do you have a button that could be used instead?

Greetings -

He just wants to close individual spreadsheets by using the program X instead of the little black X, which is located just underneath the program X.

It is apparently easier to reprogram the computer then to reprogram the user.

 

[Cleffer]

Does that make sense?

Certainly does.

So, I'm assuming that MS figured that closing Excel was just supposed to work fine this way and did not allow a user access to make this particular change themselves without editing code? And why is that I'm I not suprised? :grin:

Functionality. Functionality. Functionality.

 

[Cleffer]

Worked like a charm.

Add "Man-God" to your self-description.

Many thanks.