Returns or sets the caption for the specified object. Read/write String.
expression.Caption
expression Required. An expression that returns one of the objects listed above.
Returns the caption for the specified object. Read-only String.
expression.Caption
expression Required. An expression that returns one of the objects listed above.
As
it applies to the Spreadsheet object.
This example displays the current date and time in the title bar of Spreadsheet1.
Sub SetTitleBar_Caption()
Dim ssTitle
Set ssTitle = Spreadhseet1.TitleBar
' Set the title bar's caption to the
' current date and time.
ssTitle.Caption = Date & " " & Time
' Enable the title bar.
ssTitle.Visible = True
End Sub