Results 1 to 10 of 10
  1. #1
    New Lounger
    Join Date
    Sep 2014
    Posts
    7
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Question how to change Excel 2003 content which shows on the toolbar?

    Is there any ways to change the Excel 2003's content which shows on window's toolbar?
    mine is show like this right now : http://oi60.tinypic.com/2d0fgd0.jpg

    that is not good. because actually my file name is called "Calculation Books", and because of word "Microsoft Excel " is in front of my file name, my file name shrink into only Calc...

    but my MS Word doesn't has this problem, it shows my file name first then added "Microsoft Word" after it, so it show like : http://oi59.tinypic.com/289m0cp.jpg

    does anybody know how to change the setting in excel in order to make my excel to show its content just like my MS word? thanks for any ideas.

  2. #2
    5 Star Lounger
    Join Date
    Jan 2004
    Location
    Praha
    Posts
    990
    Thanks
    56
    Thanked 105 Times in 90 Posts
    You can do this, but only using VBA:

    Code:
    Application.Caption = ActiveWorkbook.FullName
    You have to run this line every time you open Excel, so you could, for instance, put it into an Auto_Open() macro.

    If you only want the file name to be displayed, rather than the full path, use this line:

    Code:
    Application.Caption = ActiveWorkbook.Name
    For an even shorter caption you can simply use:

    Code:
    Application.Caption = " "
    But I cannot see how to exclude the leading dash. By the way, setting the Application Caption to a zero-length string doesn't work either.
    Last edited by MartinM; 2014-11-06 at 08:36.

  3. #3
    5 Star Lounger
    Join Date
    Jan 2004
    Location
    Praha
    Posts
    990
    Thanks
    56
    Thanked 105 Times in 90 Posts
    Well, you can get rid of the leading dash using the code . . .

    Code:
    ActiveWorkbook.Windows(1).Caption = " "
    . . . but then, if you open another Workbook, things go sadly wrong.

    I expect there's a workaround for that as well . . .

  4. #4
    5 Star Lounger
    Join Date
    Jan 2004
    Location
    Praha
    Posts
    990
    Thanks
    56
    Thanked 105 Times in 90 Posts
    OK, next curiosity.

    Using my own Workbook with Application.Caption = " " the leading dash eventually disappears from the Taskbar caption without any action on my part - but it remains at the top left of the Workbook itself.

    I have no idea why
    Last edited by MartinM; 2014-11-06 at 12:54.

  5. #5
    New Lounger
    Join Date
    Sep 2014
    Posts
    7
    Thanks
    1
    Thanked 0 Times in 0 Posts
    Thanks for reply! but I don't really know about Macro, can you please show me how to create Auto_Open() macro?

  6. #6
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    2,640
    Thanks
    115
    Thanked 651 Times in 593 Posts
    To get rid of the hyphen try

    Code:
    Public Sub TrimName()
     ActiveWorkbook.Windows(1).Caption = Null
     Application.Caption = ActiveWorkbook.Name
    End Sub
    Last edited by Maudibe; 2014-11-07 at 21:38.

  7. #7
    Super Moderator Rick Corbett's Avatar
    Join Date
    Dec 2009
    Location
    South Glos., UK
    Posts
    2,143
    Thanks
    101
    Thanked 580 Times in 464 Posts
    Have a look at Run a Macro Automatically on Opening Excel Workbook.

    Hope this helps...

  8. #8
    5 Star Lounger
    Join Date
    Jan 2004
    Location
    Praha
    Posts
    990
    Thanks
    56
    Thanked 105 Times in 90 Posts
    Maudibe,

    As I observed above, using the ActiveWorkbook.Windows(1).Caption property is fine until you open another Excel Workbook.

    Try it, and you will see the issue - the first Workbook to be opened now has a completely blank tab in the Windows Taskbar.

    Martin

  9. #9
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    2,640
    Thanks
    115
    Thanked 651 Times in 593 Posts
    Yes, I see now what you are saying...strange!

  10. #10
    5 Star Lounger
    Join Date
    Jan 2004
    Location
    Praha
    Posts
    990
    Thanks
    56
    Thanked 105 Times in 90 Posts
    You have to dynamically name the indvidual Excel tabs as Workbooks are opened/closed, using the ActiveWorkbook.Windows(n).Caption property.

    I've demonstrated to myself that it can be done manually but I'm not really motivated to automate it.

    Yet another curiosity is that Word puts the filename first and the application second, which leaves the key information visible in short tabs.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •