| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing title from default
The default title for Microsoft Excel is "Microsoft Excel - File Name". How do I change this to a custom title? -- toocold ------------------------------------------------------------------------ toocold's Profile: http://www.excelforum.com/member.php...o&userid=31608 View this thread: http://www.excelforum.com/showthread...hreadid=512988 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Changing title from default
Hi TooCold,
Try: Application.Caption = "My Custom Caption" --- Regards, Norman "toocold" wrote in message ... The default title for Microsoft Excel is "Microsoft Excel - File Name". How do I change this to a custom title? -- toocold ------------------------------------------------------------------------ toocold's Profile: http://www.excelforum.com/member.php...o&userid=31608 View this thread: http://www.excelforum.com/showthread...hreadid=512988 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Changing title from default
The file name is going to stay no matter what you do (IIRC), but the
Microsoft Excel thing can be changed... Sub Test() Application.Caption = "Tada" End Sub -- HTH... Jim Thomlinson "toocold" wrote: The default title for Microsoft Excel is "Microsoft Excel - File Name". How do I change this to a custom title? -- toocold ------------------------------------------------------------------------ toocold's Profile: http://www.excelforum.com/member.php...o&userid=31608 View this thread: http://www.excelforum.com/showthread...hreadid=512988 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Changing title from default
Hi Jim,
The file name is going to stay no matter what you do (IIRC), ActiveWindow.Caption = "My Replacement for Filename" --- Regards, Norman "Jim Thomlinson" wrote in message ... The file name is going to stay no matter what you do (IIRC), but the Microsoft Excel thing can be changed... Sub Test() Application.Caption = "Tada" End Sub -- HTH... Jim Thomlinson |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Changing title from default
Thanks. I never even thought to look there. I learned something new or just
completely forgot about it... The only caveat is that the application caption sticks to the instance of excel where as the activewindow caption sticks to the active window so if you change the window you get a new caption. This happens if you open a new workbook or... -- HTH... Jim Thomlinson "Norman Jones" wrote: Hi Jim, The file name is going to stay no matter what you do (IIRC), ActiveWindow.Caption = "My Replacement for Filename" --- Regards, Norman "Jim Thomlinson" wrote in message ... The file name is going to stay no matter what you do (IIRC), but the Microsoft Excel thing can be changed... Sub Test() Application.Caption = "Tada" End Sub -- HTH... Jim Thomlinson |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Changing title from default
Hi Jim,
so if you change the window you get a new caption. This happens if you open a new workbook or... Quite true and so, according to requirements, the workbook's activate and deactivate events can be used. The OP should also note that these settings are not persistent between Excel sessions. --- Regards, Norman "Jim Thomlinson" wrote in message ... Thanks. I never even thought to look there. I learned something new or just completely forgot about it... The only caveat is that the application caption sticks to the instance of excel where as the activewindow caption sticks to the active window so if you change the window you get a new caption. This happens if you open a new workbook or... -- |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Changing title from default
I now remember that I have seen this before but I gave up on it because it
removes the title of the spreadsheet from the Icon in the windows task bar... I was using it for a couple of templates and the users started to complian that they did not know which spreadsheet was which, without looking at them one at a time... -- HTH... Jim Thomlinson "Norman Jones" wrote: Hi Jim, so if you change the window you get a new caption. This happens if you open a new workbook or... Quite true and so, according to requirements, the workbook's activate and deactivate events can be used. The OP should also note that these settings are not persistent between Excel sessions. --- Regards, Norman "Jim Thomlinson" wrote in message ... Thanks. I never even thought to look there. I learned something new or just completely forgot about it... The only caveat is that the application caption sticks to the instance of excel where as the activewindow caption sticks to the active window so if you change the window you get a new caption. This happens if you open a new workbook or... -- |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Changing title from default
Hi TooCold,
Additionally, to restore the defaults, try: Application.Caption = Empty and ActiveWindow.Caption = False --- Regards, Norman |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| changing the title for a spreadsheet shown in IE | Excel Discussion (Misc queries) | |||
| Default font for toolbar menus and title bar | Excel Discussion (Misc queries) | |||
| changing the application name in the title bar | Excel Programming | |||
| changing chart title via vba? | Excel Programming | |||
| changing chart title via vba? | Excel Programming | |||
Hybrid Mode
