Change caption in the Title Bar
How to change the caption in the Title Bar using VBA
Sub Change_Title_Bar_Caption()
'change the first caption of the Title Bar
ActiveWindow.Caption = "First Caption"
ActiveWindow.Caption = "First Caption"
'change the second caption of the Title Bar
Application.Caption = "Second Caption"
Application.Caption = "Second Caption"
End Sub
ADJUSTABLE PARAMETERS
Title Bar Caption: Select the Title Bar caption by changing the captions in the double quotation marks in the VBA code.
Title Bar Caption: Select the Title Bar caption by changing the captions in the double quotation marks in the VBA code.
EXPLANATION
This tutorial explains and provides step by step instructions on how to change caption in a workbook's Title Bar using VBA by referencing to the first and second components of the Title Bar's caption.
This tutorial explains and provides step by step instructions on how to change caption in a workbook's Title Bar using VBA by referencing to the first and second components of the Title Bar's caption.
RELATED TOPICS
| Related Topic | Description | Related Topic and Description |
|---|---|---|
| Clear caption in the Title Bar | How to clear the caption in the Title Bar using VBA | |
| Display the current date and time in the Title Bar | How to display the current date and time in the Title Bar using VBA | |
| Display the current date and time in the Title Bar when opening a workbook | How to display the current date and time in the Title Bar when opening a workbook using VBA | |
| Display the current date and time in the Title Bar when a workbook was last saved | How to display the current date and time in the Title Bar when a workbook was last saved using VBA |