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

Home Privacy Policy Cookie Policy EULA Download All added Excel tools Sitemap Contact Us

Empowering Excel Users Worldwide for 25 Years