Octavio

There is no option to change the Caption as you wish without using code.

I realize this is the newusers group and would like to give you an easier
solution, but.................not to be.

The question now is.........how badly do you want to see the full path in the
Title Bar?


Gord

On Sat, 1 Jul 2006 18:00:30 -0400, "Octavio" wrote:

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


Gord Dibben MS Excel MVP