change the displayed title so 'microsoft exel' is not in it


D

dmvj

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.
 
Ad

Advertisements

B

Bob Phillips

Try this

Public WithEvents App As Application

Private Sub Workbook_Open()
Set App = Application
End Sub


Private Sub App_WindowActivate(ByVal Wb As Workbook, ByVal Wn As Window)
If Wb.Path <> "" Then App.Caption = Wb.Path
End Sub

'This is workbook event code.
'To input this code, right click on the Excel icon on the worksheet
'(or next to the File menu if you maximise your workbooks),
'select View Code from the menu, and paste the code
 
Ad

Advertisements

P

Parag Satpute

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 borde
so that it doesnt say 'microsoft excel (spreadsheet name)' but instead jus
says 'spreadsheet name'. I know its an excel document, i can tell from th
green x. I would much rather be able to see the title especially when i hav
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/tutorial...45-8b37cb7f3186/wpf-report-engine-part-4.aspx
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top