View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.newusers
RagDyeR RagDyeR is offline
external usenet poster
 
Posts: 3,572
Default Full path possible to be seen?

Right click in the toolbar and choose "Customize",
Click on "Commands " tab,
In the left window, scroll down to, and click on "Web",
In the right window, click on the "Address" bar, and drag to toolbar,
Or, drag to menu bar (usually more room there),
Then, while it's *still* selected, hover cursor over left or right border,
until it becomes a 2 headed arrow.
Drag to increase the size of the window, since paths may be rather long.
Close "Customize " window.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"JLatham" wrote in message
...
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