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

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 ?

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

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

On Thu, 1 Feb 2007 11:59:00 -0800, XRacr
wrote:

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 ?