Remove Microsoft Excel in the Title so I can read what it is in the tool bar.

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

JoeHart

Thread Starter
Joined
Aug 17, 2008
Messages
125
How do I remove Microsoft Excel from the title so I can see what it is when I have a lot open. I only want the document name not "Microsoft Excel-"Document Name". I have attached a picture in a word document for a better explanation. There are several excel files open but you can only read the name of three of them. One of them is called Sample. How do I get it so that it only gives me the name of the file like "Sample".
Joe
 

Attachments

Joined
Oct 20, 2004
Messages
7,837
Bomb, is there any slick way to alter the link you posted from ASAP so that instead of "Your text here" you could insert the file name?
Being lazy.... :)
 
Joined
Jul 1, 2005
Messages
8,546
Which file? The link's to a code snippet tip, not to the ASAP download itself.

:confused:
 
Joined
Oct 20, 2004
Messages
7,837
Well, it says
Code:
Sub ReplaceTitleBarCaption()
      ' Place the current files path and filename in the titlebar:
      Windows(1).Caption = ActiveWorkbook.FullName

      ' Place your own application name in the titlebar:
      Application.Caption = "Your text here"
End Sub
I hadn't read this well - does it mean that, instead of "Microsoft Excel - Book1" it would read "Your text here" or would it read "Microsoft Excel - Your text here"?
What the OP wants, I think, is instead just ActiveWorkbook.FullName without the Microsoft Excel part.
Just speaking out of ignorance - perhaps in MS mind the full name includes the program (Microsoft Excel) as well. So could you have the ActiveWorkbook.FullName but not show the first 18 characters (if I count right that would exclude "Microsoft Excel - "...???

Admittedly, this is laziness again - you could, for a file named "Operations May 2008" insert "Operations May 2008" where it says to insert "Your text here", but to have it happen automatically would be even nicer. :cool:
 
Joined
Jul 1, 2005
Messages
8,546
They're 2 different methods.

If I was to recommend one over the other -- which I wouldn't necessarily -- I'd go for running Application.Caption = "xl" one time at start-up as a balance between amount of tinkering and scale of the OP's problem.
 
Joined
Oct 20, 2004
Messages
7,837
Okay - thanks once again for teaching me stuff, however useless it may be, that I ask about.... :)
 

JoeHart

Thread Starter
Joined
Aug 17, 2008
Messages
125
Sorry I haven't responded. I just had my first baby. How would I run Application.Caption = "xl". Do I put this in a macro? Do I have to run the macro everytime I start windows? Once I run the macro will it work for all new excel workbooks? Is it possible to set this as a default?Thanks,
Joe
 
Joined
Jul 1, 2005
Messages
8,546
Yes, you put it in a macro. Like:

Sub CustomCaption
Application.Caption = "xl".
End Sub


Once you run it, it should work for all new workbooks -- provided you're not using multiple instances. IMO it would be best stored in your personal macro workbook (see Help) and assigned to a custom toolbar button so you can run when required.

However, I really do think you should reconsider how many apps you're running simultaneously, per your screenshot.
 
Joined
Oct 20, 2004
Messages
7,837
However, I really do think you should reconsider how many apps you're running simultaneously, per your screenshot.
I agree with that! I consider myself a pretty heavy user - currently I feel I am near the peak of my PC's use with 8 Excel files open, 1 pdf, 1 notepad, 1 Outlook Express, 1 Media Player, 2 folders and the browser with 2 tabs open. But that is nothing compared to what the picture shows, especially since some of mine (pdf, notepad) are pretty lightweight.
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Members online

Top