Public WithEvents App As Application

Private Sub Workbook_Open()
Dim FileN As String
Set App = Application
If App.Caption < "" Then
App.Caption = " "
End If
End Sub

With the above code you should be able to get only the File Name on the title bar....



dmvj wrote:

change the displayed title so 'microsoft exel' is not in it
01-Jun-10

How can i reduce that title displayed on the task bar and the window border
so that it doesnt say 'microsoft excel (spreadsheet name)' but instead just
says 'spreadsheet name'. I know its an excel document, i can tell from the
green x. I would much rather be able to see the title especially when i have
many open at once.

Previous Posts In This Thread:


Submitted via EggHeadCafe - Software Developer Portal of Choice
WPF Report Engine, Part 4
http://www.eggheadcafe.com/tutorials...ne-part-4.aspx