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

METHOD 1. Display the current date and time in the Title Bar when a workbook was last saved using VBA

VBA

Private Sub Workbook_AfterSave(ByVal Success As Boolean)
'display the current date and time in the second caption of the Title Bar
Application.Caption = Now()
'clear the first caption of the Title Bar
ActiveWindow.Caption = Empty

End Sub

NOTES
VBA Code: This VBA code needs to be inserted into the "ThisWorkbook" Microsoft Excel Object.

Explanation about how to display the current date and time in the Title Bar when a workbook was last saved

EXPLANATION

EXPLANATION
This tutorial explains and provides step by step instructions on how todisplay the current date and time in the Title Bar when a workbook was last saved. Using VBA this can be achieved by removing the first component of the Title Bar's caption and assigning the current time and date, through the Now() function, to the second component of the Title Bar's caption. In addition, you will need to set the Macro procedure title to Workbook_AfterSave(ByVal Success As Boolean), which means that the vba code will be run after a workbook is saved.

RELATED TOPICS

Related Topic Description Related Topic and Description
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