Toolbar text in excel vs word

[EnergyEngineer]

Random question:

When I have a word doc open and a xls open my blue windows xp tool bar text reads

"Filename-Microsoft Word"
"Microsoft Excel - Filename"

Why does excel torture me?! I want to be able to read the file name. I can obviously tell from the cute little green icon that it is an xls file!

Any ideas if there is a setting I can change?

Thanks,
~RUTH~
FYI Versions:
Word 2002
Excel 2002

[Paul]

Hi Energy,

I'm not sure of a way to do this for all workbooks, unless you load an add-in at Excel startup, but here's a way to do it for an individual workbook:

Private Sub Workbook_Open()
    Application.Caption = ActiveWindow.Caption
    ActiveWindow.Caption = ""
End Sub

That will remove 'Microsoft Excel -' from the title bar and replace it with just the file name (ActiveWindow.Caption). It then sets the ActiveWindow.Caption to blank so it doesn't show twice.

To get it back, you could simply do

Private Sub Workbook_BeforeClose(Cancel as Boolean)
    Application.Caption = ""
    ActiveWindow.Caption = ThisWorkbook.Name
End Sub

[EnergyEngineer]

Hehe I didn't try it but that is a nice trick. I was looking for a simpler option button.

I have used VB on certain xls files but never on all.

I am not sure how to get a VB code to load on excel start up for any blank xls. Let me know how and maybe I will try your trick...

~RUTH~