Excel 2007, Full Path in File Name

[TFH]

Is there a way to get the full path shown for the file name in the title bar and in the file listing that appears after selection of "office" button?

If I place the curser near these file names, I do see the full path. But it would be really helpful to see the full name displayed all the time.

 

[VoG]

For the title bar, press ALT + F11 to open the Visual Basic Editor, double click ThisWorkbook in the Project window then paste into the white space on the right

Private Sub Workbook_Open()
ActiveWindow.Caption = ThisWorkbook.FullName
End Sub

Save, close and reopen the workbook to see the effect.

I don't know how to do this for the list of files shown when you click the Office button.

 

[TFH]

That's better. Thanks Peter.