Clear caption in the Title Bar

How to clear the caption in the Title Bar using VBA

METHOD 1. Clear the caption in the Title Bar using VBA

VBA

Sub Clear_Title_Bar_Caption()
'clear the first caption of the Title Bar
ActiveWindow.Caption = Empty
'clear the second caption of the Title Bar
Application.Caption = Empty

End Sub

Explanation about how to clear the caption in the Title Bar

EXPLANATION

EXPLANATION
This tutorial explains and provides step by step instructions on how to clear the caption in the Title Bar using VBA by referencing to the first and second components of the Title Bar's caption.

Please note that this does not entirely clear the workbook's Title Bar captions. It replaces the current captions with "Excel". This component is associated with the second part of the Title Bar caption.

RELATED TOPICS

Related Topic Description Related Topic and Description
How to change the caption in the Title Bar using VBA
How to display the current date and time in the Title Bar using VBA
How to display the current date and time in the Title Bar when opening a workbook using VBA
How to display the current date and time in the Title Bar when a workbook was last saved using VBA