Excel tip: Replace Excel's default titlebarDate: 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:
' 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"
Share this page:
List of all utilities
Printer friendly page
^ Back to Top