A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Setting up and Configuration
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

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



 
 
Thread Tools Display Modes
  #1  
Old June 1st, 2010, 12:08 PM posted to microsoft.public.excel.setup
dmvj
external usenet poster
 
Posts: 1
Default change the displayed title so 'microsoft exel' is not in it

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.
Ads
  #2  
Old June 1st, 2010, 01:11 PM posted to microsoft.public.excel.setup
Bob Phillips[_3_]
external usenet poster
 
Posts: 489
Default change the displayed title so 'microsoft exel' is not in it

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


--

HTH

Bob

"dmvj" wrote in message
...
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.



  #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
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:30 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
Copyright 2004-2018 OfficeFrustration.
The comments are property of their posters.