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 ?
|