Show file location in title bar?

  • Thread starter Thread starter SirMatthew
  • Start date Start date
S

SirMatthew

Is there a way to make Excel or Word show the location of a file in the title
bar. Right now, it just shows the name of the file. I was thinking in 2003,
it showed the file location, or perhaps there was an option to show it? I
can't find the same thing in 2007 and it would be extremely helpfull to have
it! I use template files with the same name (for easy searching) but save in
different client folders, which is why I want it to display the full path.
Otherwise, I wouldn't care.

Thanks!!
 
I hope I am wrong but I don't think there is a setting for that.

You can use VBA.

Either workbook_open event code...........

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

To clear when closing...............

Private Sub Workbook_BeforeClose(Cancel As Boolean)
Application.Caption = ""
End Sub

Or a toggle macro..........

Sub CaptionToggle()
' toggles title bar between document name and full path
If ActiveWindow.Caption = ActiveWorkbook.Name Then
ActiveWindow.Caption = ActiveWorkbook.FullName
Else: ActiveWindow.Caption = ActiveWorkbook.Name
End If
End Sub

Alternative...............show the Web Toolbar


Gord Dibben MS Excel MVP
 
Back
Top