1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

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

Discussion in 'Business Applications' started by JoeHart, Sep 25, 2008.

Thread Status:
Not open for further replies.
Advertisement
  1. JoeHart

    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
     

    Attached Files:

  2. bomb #21

    bomb #21

    Joined:
    Jul 1, 2005
    Messages:
    8,546
  3. slurpee55

    slurpee55

    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.... :)
     
  4. bomb #21

    bomb #21

    Joined:
    Jul 1, 2005
    Messages:
    8,546
    Which file? The link's to a code snippet tip, not to the ASAP download itself.

    :confused:
     
  5. slurpee55

    slurpee55

    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:
     
  6. bomb #21

    bomb #21

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

    slurpee55

    Joined:
    Oct 20, 2004
    Messages:
    7,837
    Okay - thanks once again for teaching me stuff, however useless it may be, that I ask about.... :)
     
  8. JoeHart

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

    letchworth

    Joined:
    Jul 2, 2005
    Messages:
    879
    Way cool-- congratulations!

    letchworth
     
  10. bomb #21

    bomb #21

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

    slurpee55

    Joined:
    Oct 20, 2004
    Messages:
    7,837
    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.
     
  12. Sponsor

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 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/753392

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice