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-2024 ∙ ASAP Utilities ∙ A Must in Every Office BV ∙ The Netherlands
Empowering Excel Users Worldwide for 25 Years
Empowering Excel Users Worldwide for 25 Years