How to Display Full Path for File Diplayed at Top Of Workbook

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Excel 2000 is just displaying the file name in the top header of the
workbook. Can it be set up to show the full path with the file name ?
 
With some VBA, yes.

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

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

Or selectable................

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


Gord Dibben MS Excel MVP
 
Back
Top