There isn't always a simple answer. Generally the answers given here are as
simple as can be and still solve the problem. If a setting will do it,
someone will point it out. But there isn't a setting for every situation.

If you need help getting the code into the workbook event, here's a page I
set up to give the detailed process of doing it. It has links to similar
pages telling how to set up to attach code to a worksheet's events and for
just general purpose code.

http://www.jlathamsite.com/Teach/WorkbookCode.htm

The folks here do a marvelous job of providing answers to what seem to be
'trivial' questions - but with difficult answers. Often they develop help
tools beyond what Microsoft has available and share them to help everyone,
novice, jaded user and guru alike.

"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