Excel tip: Replace Excel's default titlebar
Date: 5 september 2001The 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
' 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
©1999-2026 ∙ ASAP Utilities ∙ A Must in Every Office BV ∙ The Netherlands
🏆 Winner of the "Best Microsoft Excel Add-in" Award at the Global Excel Summit 2025 in London!
For over 26 years, ASAP Utilities has helped users worldwide save time and do what Excel alone cannot.
🏆 Winner of the "Best Microsoft Excel Add-in" Award at the Global Excel Summit 2025 in London!
For over 26 years, ASAP Utilities has helped users worldwide save time and do what Excel alone cannot.