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

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

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

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

Changing title from default
 

Hi TooCold,

Additionally, to restore the defaults, try:

Application.Caption = Empty
and
ActiveWindow.Caption = False


---
Regards,
Norman

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

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

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

Changing title from default
 

Hi Jim,

I have also experienced problems with the Window menu list being rewritten.
I guess that technical feasibility is not necessarily synonymous with
desirability,



---
Regards,
Norman


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