Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Order of words in title of Excel windows
Hi,
is it possible to change the order of words in Excel window? What I mean: Actual Status - as a window's title I see: "Microsoft Excel - Document 1" Desired status - I wanna see: "Document 1 - Microsoft Excel" The "desired status" I already see e.g. in Microsoft Word. For explanation why I need it: I have e.g. 10 Excel files opened and all of them begins with Microsoft Excel. Therefore, I can not clearly recognize which file I need. Thank you for your help. JKH |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Order of words in title of Excel windows
Jim
You can get rid of the Microsoft Excel part completely and just show the filename. Private Sub Workbook_Open() Application.Caption = " " End Sub Private Sub Workbook_BeforeClose(Cancel As Boolean) Application.Caption = "" End Sub Right-click on the Excel logo left of "File" on menu and select "View Code" Paste the above into that module. Gord Dibben MS Excel MVP On Mon, 11 Dec 2006 08:32:01 -0800, Jiri Khun wrote: Hi, is it possible to change the order of words in Excel window? What I mean: Actual Status - as a window's title I see: "Microsoft Excel - Document 1" Desired status - I wanna see: "Document 1 - Microsoft Excel" The "desired status" I already see e.g. in Microsoft Word. For explanation why I need it: I have e.g. 10 Excel files opened and all of them begins with Microsoft Excel. Therefore, I can not clearly recognize which file I need. Thank you for your help. JKH |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Order of words in title of Excel windows
This VBA code helps. But it is solution only for files with this code.
Is it possible to do it in general? It means - for all files I open? Also, better without VBA programming (because of security restriction I can not use macros). JKH "Gord Dibben" wrote: Jim You can get rid of the Microsoft Excel part completely and just show the filename. Private Sub Workbook_Open() Application.Caption = " " End Sub Private Sub Workbook_BeforeClose(Cancel As Boolean) Application.Caption = "" End Sub Right-click on the Excel logo left of "File" on menu and select "View Code" Paste the above into that module. Gord Dibben MS Excel MVP On Mon, 11 Dec 2006 08:32:01 -0800, Jiri Khun wrote: Hi, is it possible to change the order of words in Excel window? What I mean: Actual Status - as a window's title I see: "Microsoft Excel - Document 1" Desired status - I wanna see: "Document 1 - Microsoft Excel" The "desired status" I already see e.g. in Microsoft Word. For explanation why I need it: I have e.g. 10 Excel files opened and all of them begins with Microsoft Excel. Therefore, I can not clearly recognize which file I need. Thank you for your help. JKH |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Order of words in title of Excel windows
Yep. You'll need an application event that looks for you opening workbooks.
See Chip Pearson's site: http://www.cpearson.com/excel/AppEvent.htm Jiri Khun wrote: This VBA code helps. But it is solution only for files with this code. Is it possible to do it in general? It means - for all files I open? Also, better without VBA programming (because of security restriction I can not use macros). JKH "Gord Dibben" wrote: Jim You can get rid of the Microsoft Excel part completely and just show the filename. Private Sub Workbook_Open() Application.Caption = " " End Sub Private Sub Workbook_BeforeClose(Cancel As Boolean) Application.Caption = "" End Sub Right-click on the Excel logo left of "File" on menu and select "View Code" Paste the above into that module. Gord Dibben MS Excel MVP On Mon, 11 Dec 2006 08:32:01 -0800, Jiri Khun wrote: Hi, is it possible to change the order of words in Excel window? What I mean: Actual Status - as a window's title I see: "Microsoft Excel - Document 1" Desired status - I wanna see: "Document 1 - Microsoft Excel" The "desired status" I already see e.g. in Microsoft Word. For explanation why I need it: I have e.g. 10 Excel files opened and all of them begins with Microsoft Excel. Therefore, I can not clearly recognize which file I need. Thank you for your help. JKH -- Dave Peterson |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Order of words in title of Excel windows
But you will still have to enable macros so if you cannot use macros I think
you're out of luck. Gord On Mon, 11 Dec 2006 15:09:54 -0600, Dave Peterson wrote: Yep. You'll need an application event that looks for you opening workbooks. See Chip Pearson's site: http://www.cpearson.com/excel/AppEvent.htm Jiri Khun wrote: This VBA code helps. But it is solution only for files with this code. Is it possible to do it in general? It means - for all files I open? Also, better without VBA programming (because of security restriction I can not use macros). JKH "Gord Dibben" wrote: Jim You can get rid of the Microsoft Excel part completely and just show the filename. Private Sub Workbook_Open() Application.Caption = " " End Sub Private Sub Workbook_BeforeClose(Cancel As Boolean) Application.Caption = "" End Sub Right-click on the Excel logo left of "File" on menu and select "View Code" Paste the above into that module. Gord Dibben MS Excel MVP On Mon, 11 Dec 2006 08:32:01 -0800, Jiri Khun wrote: Hi, is it possible to change the order of words in Excel window? What I mean: Actual Status - as a window's title I see: "Microsoft Excel - Document 1" Desired status - I wanna see: "Document 1 - Microsoft Excel" The "desired status" I already see e.g. in Microsoft Word. For explanation why I need it: I have e.g. 10 Excel files opened and all of them begins with Microsoft Excel. Therefore, I can not clearly recognize which file I need. Thank you for your help. JKH |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel pie chart title words break to next line between letters? | Charts and Charting in Excel | |||
Extending the Y-axis Title in Excel 2003 | Charts and Charting in Excel | |||
Excel shortcut/Multiple windows weirdness | Excel Discussion (Misc queries) | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
Creating a Microsoft Words document from an existing Excel spreads | New Users to Excel |