I google it and found the solution below. However, the code needs to be run each time the excel file is open in order to get the path displayed on the title bar
------------------
Sub showCaption()
ActiveWindow.Caption = ActiveWorkbook.FullName
End Sub
------------------
|