View Single Post
 
Old 07-31-2022, 08:11 AM
Jamal NUMAN Jamal NUMAN is offline Windows 7 64bit Office 2010 64bit
Expert
 
Join Date: Nov 2010
Posts: 519
Jamal NUMAN is on a distinguished road
Default

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

------------------
Attached Images
File Type: jpg Clip_987.jpg (95.8 KB, 6 views)
File Type: jpg Clip_988.jpg (106.6 KB, 6 views)
File Type: jpg Clip_989.jpg (102.8 KB, 6 views)
Reply With Quote