Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
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
Posted to microsoft.public.excel.setup
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
bugs in microsoft exel 2007 | Excel Discussion (Misc queries) | |||
Document name not displayed in Title Bar | Setting up and Configuration of Excel | |||
how to install microsoft exel | Excel Worksheet Functions | |||
How do i add to information to microsoft exel worksheet | Excel Worksheet Functions | |||
microsoft exel unable to open file | Excel Discussion (Misc queries) |