View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default 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 ?