This seems very complicated! Is there not an easier simple way? Is this
newsgroup geared to "new users" or to advanced "gurus"?
I was wondering if a simple change of setting in Options or somewhere will
do the trick.


"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Paste these into the Thisworkbook module

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

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

Alternative.....................

If you just want to toggle on/off...............

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 Sat, 1 Jul 2006 17:19:16 -0400, "Octavio" wrote:

Where to set Excell so the Excell window and file that I am working with
shows the full path (full path.xls) of where the folders are in the upper
left hand side line of the window?


Gord Dibben MS Excel MVP