View Single Post
  #3  
Old June 2nd, 2010, 11:50 AM posted to microsoft.public.excel.setup
Parag Satpute
external usenet poster
 
Posts: 2
Default Try this with Workbook_Open


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