logo ASAP Utilities

Excel tip: Replace Excel's default titlebar

Date: 5 september 2001

The Application.Caption command makes it possible to replace the default Excel caption (Microsoft Excel) with your own. (i.e. your application name).

The Windows(1).Caption command is the command Excel uses to display the name of the active workbook. I often replace this to view not only the current files name, but it's path as well.


Copy-paste friendly 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



« back
Share this page:
Home Sitemap Search List of all utilities Printer friendly page ^ Back to Top
© 1999-2017 - - - - The Netherlands

Connect with us and receive our tips that show you how to benefit from the tools in ASAP Utilities at:
Follow us on TwitterFollow us on Facebook